How to combine different tables data into a destination table using SSIS?

Problem: How to combine different tables data into a destination table using SSIS?

Solution:   Union All Transformation

The Union All transformation combines multiple inputs into one output. For example, the outputs from five different Flat File sources can be inputs to the Union All transformation and combined into one output.

Note: Unlike merge join union all does not need sorted inputs.

Example:

In the example, I would like to show we can use different source tables to combine and send the output into a single table.

Step 0: Create a new package and in the control flow drag a data flow task from tool box.

Step 1: Drag and drop two Ole DB Sources and call one as table A and another as a table B.  Next go to transformations and pull Union all transformation to combine both the tables.

  

Step 2: Edit the union all to map the inputs of each columns.

Step 3: execute the package.