Using Premium Hash

The Premium Hash component is a SSIS data flow transformation component that can be used to hash any input data.
There are two pages that can be configured:

  • General
  • Error Handling

Columns

These are then general columns settings for the input data.

SSIS Premium Hash Editor

Scope

The scope could one of the following:

  • Row level
  • Column level
Hash Algorithm

There are multiple hash algorithms that are available to use in the component. You can choose any from the below:

  • MD5
  • SHA1
  • SHA256
  • SHA384
  • SHA512
  • RIPEMD160
  • HMAC-MD5
  • HMAC-SHA1
  • HMAC-SHA256
  • HMAC-SHA384
  • HMAC-SHA512
  • HMAC-RIPEMD160
Output Column Name
Specify a name for the output column.
Hash Column Name Suffix (Only for Scope as Column level)
The column suffix for the Hash column can be specified here.
Output Value Type

There are four types of output values supported:

  • Byte Array
  • Hex String
  • Base64 Encoded String
  • .NET Hash code
Null Value Handling

There are three options to handle Null values:

  • Use empty string
  • Use default value
  • Raise an error
Column value delimiter

Specify the column value delimiter here:

  • Newline (\n)
  • Carriage Return (\r)
  • Semicolon ( ; )
  • Colon ( : )
  • Comma ( , )
  • Tab (\t)
  • Vertical Bar (|)
Column
The columns from the input can be specified here.
Input Data Type
The data type of the input column would be in this field.
Additional Properties
Format String
Specify the format string for the column
Input properties
Name
Specify the name of the output merged column.
Data Type
Choose the datatype of the output column.
Length
Specify the length of the field.
Scale
Specify the scale for the field.
Code Page
Code page value can be chosen here.
Output Properties
This can be used to set the output column properties and the properties are similar to input properties
Expression fx Icon
Click the blue fx icon to launch SSIS Expression Editor to enable dynamic update of the property at run time.
Generate Documentation Icon
Click the Generate Documentation icon to generate a Word document which describes the component's metadata including relevant mapping, and so on.

Error Handling

The Error Handling page allows you to specify how errors should be handled when they happen.

SSIS Premium Hash Editor - Error Handling

There are three options available:

  • Fail on error
  • Redirect rows to error output
  • Ignore error

When the Redirect rows to error output option is selected, rows that failed will be redirected to the 'Error Output' output of the Component.

SSIS Premium Hash - Error Output