Скачать или смотреть Copy Column Transformation || SSIS 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.

In simple it creates alias columns of the input columns. You can create any number of new columns by copying the same input column. For example using a column named “First Name” you can create any number of copied columns.Once the columns are created then you can apply transformations to the copied columns using other dataflow items.

1) Drag and Drop a Dataflow item in Control Flow designer.
2) Right click and edit on data flow task or simply double click on the data flow item.
3) Select any Data flow source and configure it by providing source info.
4) Select Copy Column Transformation and edit it by right clicking on it.
5) Select the columns for which you wish to create a copy and give Alias names as shown in the below screenshot.
6) Click on OK and you can test by adding data viewer