In this step by step SSIS Tutorial I will show you how to use Derived Column in SSIS. For the purpose of this tutorial I will use SSIS 2012
Other Versions of SSIS:
- SSIS 2012
- This blog post has been written using SSIS 2012
- SSIS 2008
- The examples we used should work in SSIS 2008
- SSIS 2005
- We suspect that this will work in SSIS 2005 as well
What is Derived Column transformation in SSIS?
The Derived Column transformation creates new columns with values by applying expressions to transformation input columns. An expression can contain any combination of variables, functions, operators, and columns from the transformation input.
Let me show you an example.
Below is my data flow task which I will double click.
I create source.
Drag and drop derived column transformation and create a data path between source and derived table.
I double click the derived table and in the grid I specify column name and use <add as new column> option and refer to two fields that exist in my source.
I click ok
I add another derived table and data viewer so I can preview the results.
Now it's just a matter of running the package and checking if the data viewer show the extra column.