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.