Merge Transformation Editor

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

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.

Options

  • 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

Tasks

Sort Data for the Merge and Merge Join Transformations

Concepts

Integration Services Error and Message Reference

Merge Join Transformation

Union All Transformation