Export (0) Print
Expand All

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft