DataPumpTransformCopy Object
The DataPumpTransformCopy object converts a source column to the destination column data type and moves the data to the destination column. DataPumpTransformCopy supports multiple source and destination columns. Destination truncation is possible by setting DTSTransformFlag_AllowStringTruncation in the TransformFlags property of the Transformation2 object. There are no transformation properties.
For more information, see DataPumpTransformLowerString Object. The DataPumpTransformCopy object is used the same way as the DataPumpTransformLowerString object in the example in that section, except that it is created as follows:
Set oTransform = oCustTask.Transformations. _
New("DTSPump.DataPumpTransformCopy")