MSBI : SQL Server Integration Service (SSIS) - Derived Column Transformation

In this post I'm going to explain How to use Derived column Transformation in SSIS Development Environment.Below are the steps to convert normal string to UPPER case.

First of create a OLE DB Source to get the Source data From the database.through the Connection Manager you can view the data of the Source table.(If you have any issue create connection via connection manager you can refer my 'SQL Server Integration Service (SSIS) - Loading Data from Excel to SQL Server Table' post )

Database table data available as below.

Then Drag and Drop the Derived Column component to Data flow Tab and create connection between OLE DB Source and Derived column component.

Double click on the Derived Column component and add the 'Address in Upper Case' and Calculated Bonus in the Derived Column Transformation Editor.

Then Drag and drop the OLE DB Destination to Data flow task and connect with Derived Column component.(Through the connection manager create connection to target table)

In the OLE DB Destination Editor we have to the mapping as below.

Then Execute the Package and output will be like below.

In the database you can see the data as below.