Union All Transformation Editor

Use the Union All Transformation Editor dialog box to merge several input rowsets into a single output rowset. By including the Union All transformation in a data flow, you can merge data from multiple data flows, create complex datasets by nesting Union All transformations, and re-merge rows after you correct errors in the data.

To learn more about the Union All transformation, see Union All Transformation.

Options

  • Output Column Name
    Type an alias for each column. The default is the name of the input column from the first (reference) input; however, you can choose any unique, descriptive name.
  • Union All Input 1
    Select from the list of available input columns in the first (reference) input. The metadata of mapped columns must match.
  • Union All Input n
    Select from the list of available input columns in the second and additional inputs. The metadata of mapped columns must match.

See Also

Other Resources

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

Help and Information

Getting SQL Server 2005 Assistance