Full Outer Join in SSIS

The Full Outer Join in SSIS is similar to SQL Full join, which returns all the records present in both the Left table and the right table. All the Unmatched rows will fill with NULL Values. In this article, we are going to perform Full Outer Join in SSIS Merge Join Transformation. Please refer to Left Outer article to … Read more

Left Outer Join in SSIS

In this article, we are going to perform SSIS Left Outer Join on two SQL tables using Merge Join Transformation. Before we start creating Package, let us see the two source tables that we use for Left Outer Join in SSIS using Merge Join transformation. Employees Table inside the Database is: Department Table inside the Database is: SSIS … Read more

Merge Join Transformation in SSIS

The Merge Join Transformation in SSIS performs SQL Joins such as Inner, Left Outer, Full Outer, and Right Outer (indirectly achieved by Swapping the tables) in Integration Services. The SSIS Merge Join Transformation is very useful for loading data into the Dimension tables in the Data Warehouse. NOTE: The Merge Join Transformation in SSIS will … Read more