SSISMHash icon indicating copy to clipboard operation
SSISMHash copied to clipboard

Packages fail to run on server

Open willim32533 opened this issue 7 years ago • 3 comments

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 <X64> (Build 9600: ) (Hypervisor).

willim32533 avatar Jun 19 '18 00:06 willim32533

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.

keif888 avatar Jun 19 '18 21:06 keif888

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?

waltheed avatar Dec 09 '19 13:12 waltheed

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.

keif888 avatar Mar 15 '23 12:03 keif888