Tag: Integration Services
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…