search

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
34 stars 6 forks source link

MultiHash 64 not working on SQL Server 2019 #21

Open jimonnet opened 2 years ago

jimonnet commented 2 years ago

I installed the latest version of MultiHash64 on my local machine and can run my SSIS packages successfully. We recently updated the server to SQL Server 2019 and installed MultiHash64 on the server. When I run my package on the server I receive errors.

"Data Flow Task - Load Stage From SAP:Error: Multiple Hash failed validation and returned error code 0xC0048021."

"Data Flow Task - Load Stage From SAP:Error: The component is missing, not registered, not upgradeable, or missing required interfaces. The contact information for this component is "http://ssismhash.codeplex.com/"."

"Data Flow Task - Load Stage From SAP:Error: The component metadata for "Multiple Hash" could not be upgraded to the newer version of the component. The PerformUpgrade method failed."

keif888 commented 1 year ago

My apologies for not seeing this earlier. Only way I can think for this scenario to happen is for the SQL Server to be upgraded after the installation of multiple hash, which would result in the previous edition of SQL Server's MultipleHash dll's being in place.

You should check for the existence of the Multiple Hash DLL's in the correct folders. eg. One of the following folders, assuming default installation of components on C:

C:\Program Files\Microsoft SQL Server\140\DTS\PipelineComponents\MultipleHash2017.dll C:\Program Files\Microsoft SQL Server\150\DTS\PipelineComponents\MultipleHash2019.dll C:\Program Files\Microsoft SQL Server\160\DTS\PipelineComponents\MultipleHash2022.dll

If they are not there, I would uninstall and reinstall Multiple Hash.