Merge Transformation Editor

 

Applies To: SQL Server 2016

Use the Merge Transformation Editor to specify columns from two sorted sets of data to be merged.

System_CAPS_ICON_important.jpg Important


The Merge Transformation requires sorted data for its inputs. For more information about this important requirement, see Sort Data for the Merge and Merge Join Transformations.

To learn more about the Merge transformation, see Merge Transformation.

Output Column Name
Specify the name of the output column.

Merge Input 1
Select the column to merge as Merge Input 1.

Merge Input 2
Select the column to merge as Merge Input 2.

Integration Services Error and Message Reference
Sort Data for the Merge and Merge Join Transformations
Merge Join Transformation
Union All Transformation

Community Additions

ADD
Show: