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.