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

After downloading the appropriate setup files, unzip them, and execute the Setup.exe file.

If you have a previous version (1.0, 1.1, or 1.2) you will get a dialog box informing you that you must uninstall the previous version. Do this, and then restart the installation.

Once the installation has completed, you will need to start BIDS, and add the new component into the Toolbox. This is done as follows:
1. Add a data flow task into a new Integration Services package
2. Open the data flow task
3. Display the Toolbox
4. Right click the Data Flow Transformations within the Toolbox
5. Select Choose Items
6. Switch to the SSIS Data Flow Items tab
7. Tick the check box next to Multiple Hash in the list
8. Ok your way out of the dialog boxes

Outputs
The component generates a single output. This output will add new columns to your data flow that will be Binary data from the Hash functions.
The following Hash functions are supported:
* MD5 Size:16
* Ripe MD 160 Size:20
* SHA1 Size:20
* SHA256 Size:32
* SHA384 Size:48
* SHA512 Size:64

Usage
1. To use, drop the component on the design surface.
2. Connect it to a Data Flow Source
3. Edit the component
4. Select the Input Columns Tab (should already be active)
5. Tick the columns that will be used for generation of the hash's. If planning more than one hash, then ensure that you select the columns for all hash's to be generated.
6. If you will have a large number of output columns, and will be excuting on a multi core machine, then consider enabling the Multiple Threading
* None will not do Multiple Threading
* Auto will do some basic checking, before enabling multiple threading (number of CPU's, and Number of Outputs)
* On will enable multiple threading (regardless of the number of CPU Core's etc

7. Switch to the Output Columns Tab
8. In the Output Columns list, enter a new column name, and then select the Hash function
9. The list to the right should now be populated with the columns that you selected on the Input Columns Tab.
10. Tick the columns that you wish to use for this Hash.
11. Repeat 8 though 10 until finished.
12. Add a Data Flow Destination
13. Connect the Output from the component to the Data Flow Destination
14. Run your SSIS component...

Requirements:
* MySQL Server 2005 or 2008

The license of this software is Free, you can free download and free use this file compare software.