Derived Column Transformation in SSIS (SQL Server Integration Services)

The Derived Column transformation creates new column values by applying expressions to transformation input columns.

We are using AdventureWorks database.You can download it from here. We have First Name,Middle Name,Last Name column in Person.Person table.
We can combine those three column and make a new column Full Name with the help of derived column.

Create a new SSIS project .Add a Data Flow Task and then add an OLE DB Source.

Now Edit Ole DB source editor as below -

We have three columns available in the OLE DB Source editor -

Now add a derived column transformation after the OLE DB Source.GO to the Derived Column Trasnsformation editor.Add a new Derived Column Full Name.Add expression  FirstName + " " + REPLACENULL(MiddleName,"") + " " + LastName

Now execute the package 

You may check the result from the SSMS -