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

Right Outer Join in SSIS

In this article, we are going to perform SSIS Right Outer Join on two SQL tables using Merge Join Transformation. Before designing the Package, let see two source tables on which we are going to perform Right Outer Join in SSIS using Merge Join Transformation. Please refer to Left Outer Join article to understand. And also, see Full Outer Join article … 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