Derived Column Transformation

This is used to derive new columns by using any of the following.

Constants or static values

Other columns

Variable values

Step 1:

Click Windows button and go to SQL Server 2008 R2 and run as a administrator.

It shows  a bellow window.

Step 2:

Go to a views and create a new project ( Short cut of New Project is Ctrl + Shift + N).

Step 3:

Give a project name (e.g. IS) and click OK button and then shows a bellow window.

Step 4:

To drag and drop the Data Flow Task

Step 5: 

To edit the Data Flow Task then it open a Data Flow

Stem 6:

To dag and drop the OLEDB source and edit it

Step 7:

To give a OLEDB connection and select the table from given data base and select which columns are required.

Step 8:

Select table as [Sales].[Sales TaxRate].

Step 9:

Dag and drop derived column transformation and edit it.

Step 10:

Add new column as DC and write a bellow expression

TaxRate < 14 ? TaxRate + 5 ; TaxRate

Step 11:

Drag and drop Data reader destination and add data viewer

Step 12:

Click on right button and excite task