This project has moved. For the latest updates, please go here.

Usage Instructions

The following should assist you in using this component.

Installation

After downloading the appropriate setup files, unzip them, and execute the Setup.exe file.
Once the installation has completed, you will need to start BIDS, and add the new component into the Toolbox.
This is done by right clicking in the Toolbox, and selecting Choose Items. From the SSIS Dataflow Components tab, tick the Multiple Hash component.

Inputs

The component needs a single input.

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:

Hash Size
MD5 16
Ripe MD 160 20
SHA1 20
SHA256 32
SHA384 48
SHA512 64

Configuration

Input Columns Tab
Output Columns Tab

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

Last edited Aug 21, 2009 at 11:52 AM by kmartin, version 2

Comments

cedricdevroey Mar 9, 2010 at 1:25 PM 
super add-in Keith. Well done!