Merge Transformation Editor
Use the Merge Transformation Editor to specify columns from two sorted sets of data to be merged.
The Merge Transformation requires sorted data for its inputs. For more information about this important requirement, see How to: 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.