November 16, 2007 at 1:59 pm
Any way to have a lookup task ignore case?
I have a file containing custid, shipid, company (name) and a table with same. When I do a compare to insure the name in the file is the same as the name in the table using a lookup task I get 12000 failures (not matching name). Doing the same in a query window gives ~3000 that don't match. Further analysis showed that the extra 9000 failures in SSIS lookup were due to case
exampl:
row in table contains St
row in file contains ST
Thanks.
November 19, 2007 at 1:35 pm
The Katmai release fixes this problem. However, that does not solve your problem now!
I suggest your convert everything to upper case so you can do the lookup successfully. Do that by adding using the "Derived Column" transformation that adds a new column that contains the value of your lookup column in upper case (i.e. use UPPER(mycol)). Then change your SQL used in the Lookup transformation to use the UPPER keyword around your lookup column.
November 19, 2007 at 2:50 pm
Thanks Doc! Worked like a charm!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply