SSIS Lookup Transform Issue with NULL

[mvlk]

I am creating a simple SSIS package to eval the product. All is working general well until I added a Lookup Transformation to my Data Flow Task. For the Lookup, I am comparing on 4 fields. If all fields have values, the result is correct. If one field has NULL in both the source and destination, the result incorrectly redirects to match.

My Source into the Lookup is MS SQL 2008 data with the Lookup OLE DB Connection Manager pointing to the Postgres connection.

Is there a configuration or something I may be missing?

[mvlk]

My bad... I was assuming this was an issue with PGNP provider... Is actually a problem with how cache mode handles NULL in SSIS itself.

Please disregard my question.