Copy Column Transformation

The Copy Column transformation creates new columns by copying input columns and adding the new columns to the transformation output. Later in the data flow, different transformations can be applied to the column copies. For example, you can use the Copy Column transformation to create a copy of a column and then convert the copied data to uppercase characters by using the Character Map transformation, or apply aggregations to the new column by using the Aggregate transformation.

Configuration of the Copy Column Transformation

You configure the Copy Column transformation by specifying the input columns to copy. You can create multiple copies of a column, or create copies of multiple columns in one operation.

This transformation has one input and one output. It does not support an error output.

You can set properties through the SSIS Designer or programmatically.

For more information about the properties that you can set in the Copy Column Transformation Editor dialog box, see Copy Column Transformation Editor.

The Advanced Editor dialog box reflects the properties that can be set programmatically. For more information about the properties that you can set in the Advanced Editor dialog box or programmatically, click one of the following topics:

• Common Properties

• Transformation Custom Properties

For more information about how to set properties, see Set the Properties of a Data Flow Component.

Related Content

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN: Visit the Integration Services page on MSDN For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Zobacz także

Koncepcje

Data Flow

Integration Services Transformations