Creator:
Keith MartinDescription: 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 TabBinary Download:
SSIS Multiple Hash on Codeplex, Releases TabInstructions:
SSIS Multiple Hash Component WikiThis 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):