SSIS Lookup Transform Issue with NULL

More
9 years 9 months ago #487 by mvlk
mvlk created the topic: SSIS Lookup Transform Issue with NULL
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?

Please Log in or Create an account to join the conversation.

More
9 years 9 months ago #488 by mvlk
mvlk replied the topic: Re: SSIS Lookup Transform Issue with NULL
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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.067 seconds
Powered by Kunena Forum