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
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
