Thursday 12 May 2016

Copy column transformation in SSIS

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.

Popular Posts