Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
SQL Server
SQL Server 2008
Technical Reference
Feature Reference
 Merge Transformation Editor
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (October 2008)
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.

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.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2008 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker