This is a Fast Forward tutorial on Union All Transformation in Microsoft SQL Server Integration Services.

Union All

The Union All transformation combines data from multiple inputs into one output. This transformation has multiple inputs and only one output. It does not support an error output. The metadata of the columns from multiple inputs must match. Union All is similar to union all set operation as in databases.

Implementation

Let us create a Data Flow. Let us take try to use the Union All transformation to stage the employee information from three department locations coming as flat files. Here we want to stage the flat file data of employee details to a target table.

Control Flow

Here we have three Flat File Source followed by Union All transform and finally OLEDB Destination target table.

Data Flow

Connect the inputs from the flat file sources to the Union All transformation. The inputs should have the exact number of columns and datatypes. Input column alias name can differ. Also we can change the Output Column Name alias. Double-click the transformation to open the editor and define the output mapping.

Union All Split Transformation Editor

Union All Split Transformation  Properties

Finally execute the package and verify the result.


Have a question on this subject?

Ask questions to our expert community members and clear your doubts. Asking question or engaging in technical discussion is both easy and rewarding.

Are you on Twitter?

Start following us. This way we will always keep you updated with what's happening in Data Analytics community. We won't spam you. Promise.

  • SSIS- Derived Column Transform

    This is a Fast Forward tutorial on Derived Column Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Conditional Split Transform

    This is a Fast Forward tutorial on Conditional Split Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Aggregate Transform

    This is a Fast Forward tutorial on Aggregate Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Merge Join Transform

    This is a Fast Forward tutorial on Merge Join Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Multicast Transform

    This is a Fast Forward tutorial on Multicast Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Union All Transform

    This is a Fast Forward tutorial on Union All Transformation in Microsoft SQL Server Integration Services.

  • SSIS- Lookup Transform

    This is a Fast Forward tutorial on Lookup Transformation in Microsoft SQL Server Integration Services.