How to add a new Column from existing Columns in Data Flow Task - SQL Server Integration Services

In this video you will learn the answer of SSIS Interview Question "
If you need to add a new column(s), which transformation will you use in SSIS Package"

You will learn how to use Derived column transformation in SSIS to add new column or replace existing column.
How to write expressions in Derived Column Transformation in SSIS Package

Complete List of SSIS Interview Questions by Tech Brothers

[krismaly]

I enjoyed watching this video and recommend to others.

Thanks for educating the community and appreciate your volunteership.

Thanks a bunch

[krismaly]

I enjoyed watching this video and recommend others to watch.

Thanks for educating the community and appreciate your efforts.

Thanks a lot

[qzlkddg]

I have a scenario where we don't usually prefer altering the DB objects structure, and I have to get a column from the source joining a view and a table.
Now, I derived the column in SQL server and able to get it into my destination, but if I try this whole process using SSIS, its unable to parse the columns for the "Derived column", reason being its not able to see that column into the list of permanent columns, thus while "adding some select query in the derived column transformation", its not parsing the expression and failing.

How to deal with such scenario?
Thanks in advance!

[subramaniansadagopan]

When I want to load the data into excel destination, I am getting the full name column along with first name and last name fields. After concatenation, I need only fullname in destination..How to remove the first and last name fields.

[ayaansh]

how to separate full name into first name and last name

[krishnakavya]

I thought it was about concrete columns 🤭