Merge Join Transformation Editor

Use the Merge Join Transformation Editor dialog box to specify the join type, the join columns, and the output columns for merging two inputs combined by a join.


 The Merge Join 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 Join Transformation in the data flow. The output for the source or transformation should have its IsSorted property set to True; moreover, an appropriate SortKey value 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 Join transformation, see Merge Join Transformation.


  • Join type
    Specify whether you want to use an inner join, left outer join, or full join.
  • Swap Inputs
    Switch the order between inputs by using the Swap Inputs button. This selection may be useful with the Left outer join option.
  • Input
    For each column that you want in the merged output, first select from the list of available inputs.
Inputs are displayed in two separate tables. Select columns to include in the output. Drag columns to create a join between the tables. To delete a join, select it and then press the DELETE key.
  • Input Column
    Select a column to include in the merged output from the list of available columns on the selected input.
  • Output Alias
    Type an alias for each output column. The default is the name of the input column; however, you can choose any unique, descriptive name.

See Also

Other Resources

Integration Services Error and Message Reference
How to: Extend a Dataset Using the Merge Join Transformation
Merge Transformation
Union All Transformation

Help and Information

Getting SQL Server 2005 Assistance