The time zone conversion component can be used to convert values from a date column from one timezone to another.
The general page contains general settings for the time zone conversion component.
- 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.
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 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.