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

Cannot selectively choose hash columns #11

Closed aaronjd closed 6 years ago

aaronjd commented 6 years ago

I'm working on a newer SSIS project using version of VS 2017 SSDT (Version 15.5.2) targeting SQL Server 2017. The machine has Windows 2012 R2 Datacenter. I am using 1.7.2.0 of Multiple Hash. I cannot selectively choose hash columns to include in the hash. I am only able to select all columns in the column header.

image

keif888 commented 6 years ago

Tested on Windows 10, Microsoft Visual Studio Enterprise 2017, Version 15.5.7 (SSDT 15.1.61710.120) and is working correctly. I will have to build a system to your spec above to test.

Please note that many years ago I encountered similar issues with a specific build of Windows Server, which was fixed in a later service pack.

aaronjd commented 6 years ago

Thanks! Let me know if there is anything else I can provide.

keif888 commented 6 years ago

Just built the server, and installed VS2017 SSDT 15.5.2. Looks like there is an issue with the VS2017 SSDT, as it does NOT register the SQL2017 registry settings, or for that matter install the SQL2017 files. As such the SSISMHash installer can't detect that SQL2017 is on the system, and chooses not to install the DLL's for SQL2017. I did a custom install including the SQL2017 DLL's.

Subsequent testing has shown no issues. image image

keif888 commented 6 years ago

I just noticed that the version that I installed is a slightly higher build number than the one that you had installed. Can you please test with the latest version of SSDT's?

aaronjd commented 6 years ago

Awesome. I'll test and verify with latest version.

aaronjd commented 6 years ago

Thanks, that worked.