SSIS Lookup Transform Issue with NULL

Using PGNP with MS SQL Server, Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Linked Servers, Snapshot and Transactional Replication and more.

SSIS Lookup Transform Issue with NULL

Postby mvlk » Fri Oct 15, 2010 3:03 pm

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
 
Posts: 2
Joined: Fri Oct 15, 2010 2:55 pm

Re: SSIS Lookup Transform Issue with NULL

Postby mvlk » Fri Oct 15, 2010 3:56 pm

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.
mvlk
 
Posts: 2
Joined: Fri Oct 15, 2010 2:55 pm


Return to SQL Server/DTS/SSIS/Linked servers/Replication

Who is online

Users browsing this forum: No registered users and 3 guests