Conditional Split fails if value is NULL in SSIS -

i passing result of full outer join conditional split , filtering records on basis of following rules . both tables has same schema , primarykey values same.

a. if primary key of source null b. if primary key of destination null c. if source , destination key matches.  

it works fine (a) , (b) fails (c)

source.id == destination.id 

and throws exception condition evaluated null boolean expected. how can make work?

conditional split gets input merge join , it's full outer join need full outer join results here

your third condition should start isnull check again before compare values. following:

!isnull(source.id) && !isnull(destination.id) && source.id == destination.id 

you need handle every column can null in condition. since comparing id's, option be:

(isnull(source.id) ? 0 : source.id) == (isnull(destination.id) ? 0 : destination.id) 

if comparing strings, can replace zeroes blank spaces.