SSIS Tutorial Part 75- How to use Merge Transformation in SSIS Package

In this video you will learn the answer of SQL Server Integration Services(SSIS) Interview Question
"If we have source S1 and Source S2, and we need to merge them so that we get sorted output, which transformation would we use in SSIS Package?"

To follow Step by Step SQL Server Integration Services(SSIS) Video Tutorial By TechBrothers, please open below link.

[krismaly]

I enjoyed watching this video and recommend others to watch.

Thanks for educating the community and appreciate your efforts

[danieljoubert]

Thanks for this, again it would help if you share source scripts as I had to recreate them from scratch, Luckily I used previous data in a SSIS Package to populate the sample data.

[aliazad]

hi
Thanks a lot for your tutorial.
I do have a question.
How I can extract various kind of data (with various Types) from for example 7 ODBC sources, and then merge all these various types of data and use them in just one table as ODBC Source?
Let us not forget that there is no Key between these ODBC sources and I can not use Merge or Merge Join.

Thanks a lot for consideration.

[jeelaswani]

sir what to do if don't want to use the sort that is, directly taking merge tranformation after OLEDB sources.

[jcasanova]

I replaced the "Sort" components for system configuration of the "OLE DB Source" however has not worked for me. The "Merge Join" does not produce results.

[vanimalge]

I have to use the Tsql merge statement and insert if data is new and update if there is any update between source and target which are on 2 different servers so wanted to go through SSIS tool will merge task resolve this issue ?

[krismaly]

I enjoyed watching this video and recommend others to watch.

Thanks for educating the community and appreciate your efforts.

Thanks a lot