ssis - Non-matching records on a join

[John Walsh]

How do I get the non-matching records of a merge join to be the output of a
merge join. actually it doesn't matter if they are the output...I just need
to do something with these records....is there another "task item" I can use
to achieve this?

[Todd C]

Hello John:

Here is what I typically do: Set up your Merge Join to be a LEFT OUTER JOIN,
instead of INNER. Then downstream of that, put in a Conditional Split that
looks for a NULL in a field from the LEFT side of the join.

HTH
=====
Todd C

Post by John Walsh
How do I get the non-matching records of a merge join to be the output of a
merge join. actually it doesn't matter if they are the output...I just need
to do something with these records....is there another "task item" I can use
to achieve this?