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.
To get full access to this page
Become a member or Sign in
Membership is just $3.99/month