Transformation Properties U ...


SQL Server 2008 Books Online (October 2009)
Merge Transformation Editor

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

ms186825.note(en-us,SQL.100).gifImportant:
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.

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

Concepts

Integration Services Error and Message Reference

Other Resources

How to: Sort Data for the Merge and Merge Join Transformations
Merge Join Transformation
Union All Transformation

Help and Information

Getting SQL Server 2008 Assistance
Tags :


Page view tracker