How to use "not in" operation

Dear friends, I was not able to find any perfect toolbox item to use "not in" operation on my selected columns, also how can we use multiple join conditions in the merge join item? Thanks,

Jwalant Natvarlal Soneji wrote:

Dear friends, I was not able to find any perfect toolbox item to use "not in" operation on my selected columns,

Do you want to know if a certain row is not in some other table? This should help:

Checking if a row exists and if it does, has it changed?

(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

Jwalant Natvarlal Soneji wrote:

also how can we use multiple join conditions in the merge join item? Thanks,

Just join multiple columns together. There is nothing limiting you to just one join condition.

-Jamie