Geeks With Blogs
Totzkeeeeee's Blog Just because I can... February 2007 Entries
SSIS Lookup Transformation Case Sensitivity
Hey there, In one of my data loads I have NULLs creeping into a foreign key column. I am looking up a domain name and getting an integer Id number back. The column is populated during the load by a Lookup Transformation in SSIS. A previous step in the process populates the lookup table with any values that don’t exist so it should be impossible for the subsequent lookups to fail. These null values had only recently appeared and coincided with some data back-filling we were doing. First issue: I had ......

Posted On Tuesday, February 6, 2007 10:34 AM

Copyright © David Totzke | Powered by: