Visualizing what Merge Transformation in SQL server Integration Services (SSIS) does:

Standard

Visualizing stuff is powerful – if you have visualized something then you can remember it for a longer period of time. So in this post, we will visualize what the Merge Transformation in SQL Server Integration services (SSIS) Does:

merge tranformation SQL Server Integration Services

Note:

1) Do not Confuse it with Merge Join Tranformation. “Merge Join” is NOT same as “Merge”

2) Merge Transformation can accept only TWO (sorted) data sources. Whereas if you want to “combine” more than two data-sets, then go for Union ALL tranformation

One thought on “Visualizing what Merge Transformation in SQL server Integration Services (SSIS) does:

What do you think? Leave a comment below.