Using the Time Zone Conversion Component

The Time Zone Conversion Component can be used to convert values from a date column from one time zone to another. The component also automatically adjusts for daylight saving changes when converting between different time zones including UTC.

General Page

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

SSIS Time Zone Conversion - General

Input Column

An input column can be selected from any available date columns in the attached input. Clicking on the button will open the below page, from which you can choose one or more columns.

SSIS Time Zone Conversion - Select 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.

Output Columns Suffix (Available when Output date value to a new column is chosen)

The output column suffix can be provided in the field.

Output Column Type (Available when Output date value to a new column is chosen)

Chose between the Default type or Date time offset type from the drop-down field.

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 green output connection represents 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 the server or the component itself.

SSIS Time Zone Conversion - Error Output