March 31, 2011 at 7:02 pm
Hi,
Does any one know that 'like' operator does work / does not work in Lookup task custom query?
To it is not working in Lookup task and passing all rows to not matched.
I have tested it for 1 rows for which it should match but it didn't.
ID in Source1 = ‘F26D454C’
ID in Data Warehouse = ‘1F26D454C’
Added ‘%’ to ID of Source1 column i.e '%F26D454C'
Not Worked in Lookup
? is ID column from Source i.e '%F26D454C'
select * from DIM_Table
where ID like ?
If I use = operator in Lookup task it works.
Worked in SSMS
select * from DIM_Table
where ID like '%F26D454C'
----------------------------------
If like operator do not work .. whats the other way around.
April 4, 2011 at 7:35 pm
No one has ever used 'Like' operator in Lookup Custom query ??????
April 5, 2011 at 12:00 pm
I have to admit that I have never even tried, I have used lookup very often. As a workaround you might add a RIGHT statement to your initial query as an additional column then you can do an equals match easier.
CEWII
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply