SSIS Concepts
Posted in SSIS

SSIS – Merge Join vs Lookup Transformation

What is the difference between Lookup and Merge Join transformation in SSIS? Lookup and Merge Join component in SSIS are primarily used for joining two…

Continue Reading...
SSIS Concepts
Posted in SSIS

SSIS – Difference between Merge and Merge Join

We can use Merge or Merge Join transformation to combine data in SSIS. Lets look at what is the difference between these two transformations and…

Continue Reading...