Share via

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 inputs. If you do not use the Sort transformation to prepare the dataset, then you must set the appropriate properties on the source or on the asynchronous transformations that precede the Merge Transformation in the data flow. The output for the source or transformation should have its IsSorted property set to True; moreover, appropriate SortKey and ComparisonFlag values should be set on the specific output column. For more information, see How to: Set Sort Attributes on an Output.

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.

See Also

Other Resources

Integration Services Error and Message Reference
Merge Join Transformation
Union All Transformation

Help and Information

Getting SQL Server 2005 Assistance