SSIS Multiple Hash

Creator: Keith Martin

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

Design Page Example



Meta Data from Example



Main Project Site: http://ssismhash.codeplex.com/

Source Download: SSIS Multiple Hash on Codeplex, Source Code Tab
Binary Download: SSIS Multiple Hash on Codeplex, Releases Tab

Instructions: SSIS Multiple Hash Component Wiki

This component has now been updated to version 1.4
This release improves the UI for selection of columns in the Hash, and the ordering of these columns.
It also includes Denali support.

Version 1.3.1 Details:
Corrects an issue with Multiple Threading and Thread Safe not being enabled.

Version 1.3 Details:
This release adds the ability to upgrade an SQL 2005 package to SQL 2008.
This release adds the ability to detect the following scenarios:

Version 1.2.1 or lessor

Col 1	Col 2	Col 3	Hash
Text	NULL	Text 2	0x123456
Text	Text 2	NULL	0x123456
NULL	Text	Text 2	0x123456

Version 1.3 without Safe Ticked (This is the default action on an update)

Col 1	Col 2	Col 3	Hash
Text	NULL	Text 2	0x123456
Text	Text 2	NULL	0x123456
NULL	Text	Text 2	0x123456

Version 1.3 with Safe Ticked (You have to enable this in your existing packages)

Col 1	Col 2	Col 3	Hash
Text	NULL	Text 2	0x123564
Text	Text 2	NULL	0x124563
NULL	Text	Text 2	0x823456

Note that all the hashes are different in this case, and they are different from those generated by the older versions.
This is because columns that are variable length will have their length appended to a string at the end of the hash data, and all columns will have their NULL status added to the same string. That string is then added to the data read in, and hashed.

Review(s):