SSIS Merge Join Transformation left outer join where col is null

 Problem:

    I have 2 tables, I need to get the details of the "partid" which are in left table and not in right table.

Solution

• Here I am using conditional split to get only the partid with null from right table.