Copy Column Transformation

Copy Column Transformation helps you in creating new columns by copying input columns and adding the new columns to the transformation output. In simple it creates alias columns of the input columns. 

Step 1:

Click Windows button and go to SQL Server 2008 R2 and run as a administrator.

It shows a bellow window.

Step 2:

Go to a views and create a new project (Short cut of New Project is Ctrl + Shift + N).

Step 3:

Give a project name (e.g. IS) and click OK button and then shows a bellow window.

Step 4:

To drag and drop the Data Flow Task

Step 5: 

To edit the Data Flow Task then it open a Data Flow

Stem 6:

To dag and drop the OLEDB source and edit it.

Step 7:

To take OLEDB connection and select the table from given data base and select which columns are required.

Step 8:

Drag and drop the copy column and edit it.

Step 9:

Select which column you want

.Step 10:

Take a data reader destination and give a connection and edit it

Step 11:

Take a data viewer and view the final report.

Step 11:
Execute task