Totzkeeeeee's Blog

Just because I can...

  Home  |   Contact  |   Syndication    |   Login
  216 Posts | 4 Stories | 345 Comments | 321 Trackbacks

News


My blog is worth $14,678.04.
How much is your blog worth?

Tag Cloud


Archives

Blog Roll

Cool Sites

February 2007 Entries

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 ......