December 5, 2011 at 3:55 am
Hi All
I've got my data about 10 miilion records and I want to compare my suburbs (varchar(26)) againts a national database of suburbs (varchar80)) long. I get a warning message when I try and compare these 2 fields.
I like to get rid of all warning messages if at all possible, and I've noticed if I select "Ignore symbols" in the comparision flags, in the relationships, the package wont even run (VS_IsBroken error)
Should I really care about the warning, or can I do something about it?
Many thanks
December 5, 2011 at 4:02 am
What is the warning message?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 4:06 am
Jsut that the input column lenght is not the same as the reference column lenght. I know, not the end of the world, but...
But as mentioned, if selecting the Ignore symbols, in the relationships, it give the is broken error and cant run at all.
So my thinking is that you must be able to also have a derived column for a reference table as well?
December 5, 2011 at 4:56 am
chris.stuart (12/5/2011)
Jsut that the input column lenght is not the same as the reference column lenght. I know, not the end of the world, but...But as mentioned, if selecting the Ignore symbols, in the relationships, it give the is broken error and cant run at all.
So my thinking is that you must be able to also have a derived column for a reference table as well?
The width is easily fixed, so you can avoid all your problems 🙂
But what happens if you run the transformation with the warning?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 5, 2011 at 9:48 pm
The package runs, no problem, seems to do the look-up just fine..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply