NULL in the SSIS Merge Join Task

September 17, 2007

I was doing a little bit of FULL OUTER JOIN work with the Merge Join task and noticed that NULL = NULL.  This may seem logical, but in SQL Server RDBMS, NULL does not equal NULL.

I was a little suprised to find this out – but it isn’t hard to work around.