troubleshooting Question

SSIS - Lookups on a column of nulls

Avatar of i2mental
i2mentalFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
4 Comments1 Solution2540 ViewsLast Modified:
I'm doing a lookup in SSIS. My original source was an excel spreadsheet. The column I'm looking up contains all null values. This is an optional field in our database and may or may not have values in it. If it does have a value, I want to perform a lookup operation.

The problem I'm running into is that when I perform this lookup as the lookup yielded no results. This lookup has the default cache settings. I've read on technet that if the operation is pre-cached that it handles nulls. I sure doesn't seem like it to me.

I could just ignore error within that operation and the job completes as normal, but I do want it to fail if the column actually has a value that doesn't have a match in the lookup table.

Does anybody know how I can handle this null column? There will be a whole bunch of these columns in this package.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros