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...
SSIS Concepts
Posted in SSIS

SSIS – Synchronous and Asynchronous Transformations

All the dataflow components available in SSIS can be categorized as either Synchronous or Asynchronous components. Synchronous components¬†(non-blocking) A simple explanation of Synchronous transformation is…

Continue Reading...