Merge transformation

Step by Step Merge transformation control in SSIS TIP #122

In the Series of Zero to hero in SSISĀ  this is another post. In this post we are going to discuss Merge transformation control. By the name it is clear that Merge transformation do some merge related task. For example suppose there is two sources which are source1 and source2. Now we want merge records …