Tuesday, August 18, 2015

Copy column Transformation in Data Flow Task

Copy column Transformation in Data Flow Task

- It will allow us to add a new column by copying the data from existing column

EXAMPLE

1. Add a Data Flow Task

2. Inside Data flow Task, flow will be like this
           
3. In copy column transformation, select the columns to which you want to copy and give different alias
4. Do proper column mapping in Destination