Share via


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

Tasks

Merge Data by Using the Union All Transformation

Concepts

Integration Services Error and Message Reference

Merge Transformation

Merge Join Transformation