The Copy Column Transformation
simply takes an input column and creates a duplicate of it with a new name. In
simple word we say that it creates alias columns of the input columns. We can
create any number of new columns by copying the same input column. This is
very important transformation because if we want to perform multiple operations
on single column then we can create multiple copies and later we can perform
one operation on one copy.
Implementation of Copy Column
Taking Data flow task
Double click on the Data flow task
In Data flows pane I am taking source as OLEDB source
Now I am creating required connection.
Click ok.
Now I am taking Copy column transformation.
Double click on this transformation. Copy Column
transformation Editor will open. You can select the column by checking the
check box or you can select the column name from input column drop down list. By default output Alias will be created as Copy of [Column].
You can change this Alias name as you need.
Click ok.
Now I am taking multicast transformation and adding Data
viewer to see the result.
Double click on the Data viewer
Click ok and execute the package.
Copy column transformation only makes a new copy.
No comments:
Post a Comment
If you have any doubt, please let me know.