NULL in the SSIS Merge Join Task

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.

Advertisements

One Response to NULL in the SSIS Merge Join Task

  1. Tod McKenna says:

    FYI: You can set the property “TreatNullsAsEqual” on the Merge join componenet. The default is “True”, I believe.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: