Union All & Merge transformations are used to append datasets together. This post demonstrates how to configure both transformation and discusses the relative benefits of each.
Using Union all & Merge transformations to append datasets in SSIS.
« Using Merge Join Transformations in SQL Server Integration Services (SSIS).
Using Aggregate & Data Conversion Transformations in SSIS »
