Using the Time Zone Conversion Component

The time zone conversion component can be used to convert values from a date column from one timezone to another.

General

The general page contains general settings for the time zone conversion component.

SSIS Time Zone Conversion

Input Column

An input column can be selected from any available date columns in the attached input.

Input Time Zone

The time zone that the input column currently uses.

Output Time Zone

The time zone that the dates from the input column should be converted to.

Replace date value in input column

The value in the input column will be replaced with the new date.

Output date value to a new column

The new date value will be output to a new column.  The name of the column must be specified.

Error Handling Page

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

SSIS Time Zone Conversion - Error Handling

There are three options available. 

  1. Fail on error
  2. Redirect rows to error output
  3. Ignore error

When the Redirect rows to error output option is selected, rows that failed to be sent will be redirected to the 'Error Output' output of the Transformation Component. As indicated in the screenshot below, the blue output connection represent rows that were successfully sent, and the red 'Error Output' connection represents rows that were erroneous. The 'ErrorMessage' output column found in the 'Error Output' may contain the error message that was reported by server or the component itself.

SSIS Time Zone Conversion - Error Output