O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Merge and Union All transformations: combining input data rows

Merge and Union All transformation components are used to join data in the pipeline. This data may come from more than one source, or have been divided previously in the pipeline. The main reason we use these components is to avoid duplicate work in the pipeline because the data at this point forward has the same treatment.

The main differences between the two components are that Merge component requires input data sorted and it's not possible to have more than two inputs. There are sufficient reasons from consider this Merge component useless.

Merge and Union All transformations: combining input data rows

Getting ready

To get ready for this recipe, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required