Copy Column Transformation
A Copy Column transformation copies data directly from source to destination columns, without Microsoft® ActiveX® scripts or any other transformations applied to the data. When copying data in this manner, you should consider the following:
- Specify columns. You can specify a Copy Column transformation from a single source column to a single destination column, or from multiple source columns to multiple destinations columns.
- Make conversions. You can use transformation flags to enforce the stringency with which data type conversions are allowed. These transformation flags are available when creating or editing a transformation in Data Transformation Services (DTS) Designer, or programmatically. By default, DTS allows all possible conversions between source and destination columns.
For more information, see DTSTransformFlags.
- Truncation issues. The copy column transformation truncates text without error or notification. Although you can set transformation flags to prevent the possibility of truncation, there is no way to have the transformation fail on the first row for which truncation is necessary.
- Change the columns in the copy. When using the Copy Column transformation to copy multiple source and destination columns, it is possible to copy the same column to multiple destination columns.