Tag: Sort
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…
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…
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…