September 24, 2007 at 6:23 pm
Gents,
My SSIS package lookup function is not finding a lookup for 3 (out of 440) store codes (and isn't returning the store_DID column for that store). I can definitely confirm that these exist in my Store table.
I have redirected the rows into a temporary table, run an update statement over them, and successfully resolved all the dimension ID's for these 3 store codes that failed in the lookup.
I just cant work out why the SSIS lookup function isn't picking them up.
Anyone else seen this ?
The error is: "Row yielded no match during lookup"
Cheers.
September 24, 2007 at 7:43 pm
Resolved the problem, although it was a strange resolution.
All store codes in both the source and destination databases were at the same length. But rtrimming the store on the lookup operation managed to fix it.
Not sure at this stage why that would be the case, but it works now.
September 24, 2007 at 8:19 pm
Glad you found the problem. I run into this a lot actually, as I get a good deal of data in text files from foreign systems. I got so tired of writing LTRIM(RTRIM(value)) that I created a UDF to do the same thing when I call Trim().
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply