September 17, 2013 at 11:44 pm
Hi Everyone,
I am having a problem while using Lookup
Scenario : i am loading Dimension table and Fact Table in a package and while loading Dim Table i am using Lookup, for any new
records by using no match output to destination in lookup but Dim Table failing saying that Can't insert Duplicate Rows when i use the
data viewer it is showing unique rows only i am little confused so please can any one help me.
Thanks,
Kumar
September 18, 2013 at 1:19 am
The SSIS lookup task is case sensitive when it does comparisons, and there is a reasonable chance your database is set to a case insensitive collation. That would mean the SSIS lookup treats "A" as <> "a", whereas SQL server treats them the same.
That is only a guess based on what you said, but maybe worth a check.
Mike John
September 18, 2013 at 2:40 am
naresh.d14 (9/17/2013)
Hi Everyone,I am having a problem while using Lookup
Scenario : i am loading Dimension table and Fact Table in a package and while loading Dim Table i am using Lookup, for any new
records by using no match output to destination in lookup but Dim Table failing saying that Can't insert Duplicate Rows when i use the
data viewer it is showing unique rows only i am little confused so please can any one help me.
Thanks,
Kumar
Also make sure there are no trailing spaces.
In the query for the lookup component (you better not use the dropdown box), it's best if you put LOWER(LTRIM(RTRIM(mycolumn))) around every column used for matching. Also do the same for incoming columns from the source.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply