DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
No votes yet


Overview

Data flow transformation, converting date/time columns from one timezone to another.


Setup

The script has the following parameters:

  • TimeColumns - selects input date/time columns to convert.
  • InputZone - selects input time zone.
  • OutputZone - selects output time zone.

Requirements

Depends on COZYROC Script Component Plus for implementing parameters user interface.
Depends on .NET 3.5


Library references

  • System
  • System.Core
  • Microsoft.SqlServer.TxScript
  • Microsoft.SqlServer.PipelineHost
  • Microsoft.SqlServer.DTSPipelineWrap
  • Microsoft.SqlServer.DTSRuntimeWrap
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.Web.Services
  • System.XML
  • System.Data

ScriptMain