Union All Transformation Editor
Applies To: SQL Server 2016
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.