Packages fail to run on server

keif888 / SSISMHash

SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.

Microsoft Reciprocal License

33 stars 6 forks source link

Packages fail to run on server #14

Open willim32533 opened 6 years ago

willim32533 commented 6 years ago

After upgrading our local machines to MultipleHash 1.7.3, VS2017 successfully loads the component and it will run locally; however, after deploying the upgraded packages to the SSIS Server, it fails to run reporting, "The component is missing, not registered, not upgradeable, or missing required interfaces." The server is running Microsoft SQL Server 2016 (SP1-CU7-GDR) (KB4057119) - 13.0.4466.4 (X64) Enterprise Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 (Build 9600: ) (Hypervisor).

keif888 commented 6 years ago

Can you please check that the required DLL's are installed into the correct locations on the server?

c:\Program Files\Microsoft SQL Server\130\DTS\PipelineComponents c:\Program Files (x86)\Microsoft SQL Server\130\DTS\PipelineComponents c:\Windows\Microsoft.NET\assembly\GAC_MSIL\MultipleHash2016\v4.0_1.0.0.0__51c551904274ab44

And confirm from add/remove programs that the installer version was in excess of 1.7.0.

waltheed commented 4 years ago

I have the same issue - with sql server 2017. The packages run fine in visual studio. The dll's are in the folders on the server. What else could be wrong?

keif888 commented 1 year ago

Most likely cause of this issue is for the development to be done with a Multiple Hash 1.7 version, and the target server to have Multiple Hash 1.6 on it.