August 4, 2011 at 9:57 am
I created a conditional split to direct rows into separate spreadsheets based on a column value from a SQL query.
The following conditions worked correctly when determining the values 1-5 in the location column
Condition
Location < "2"
Location > "1" && Location < "3"
Location > "2" && Location < "4"
Location > "3" && Location < "5"
Location > "4"
The following conditions did not work when testing for the values of 1-5
Location == "1"
Location == "2"
Location == "3"
Location == "4"
Location == "5"
Has anyone seen this anomaly? The above comparisons should be identical
August 4, 2011 at 11:21 am
I hope you are missing the data conversions.
August 5, 2011 at 8:34 am
I did not understand your response!
August 5, 2011 at 9:13 am
SSIS tends to be a little sensitive to spaces at the end of fields, since it looks like you are using text for the locations you need to be aware of the datatype being used to feed the conditional split. trim off any spaces before the split is attempted and this will probably work. What leads me down that path is two fold, personal experience and the > < method seems to work, which I could see if spaces were involved.
CEWII
August 5, 2011 at 11:35 am
Probably a given, but I assume your values are not in a decimal, float, money, or some other non-integer data type? If they are, then your comparison using greater than and less than operators, will return different results than your comparison using equals operators.
August 5, 2011 at 12:13 pm
Thanks Elliot
Trim function took care it
Thanks a bunch
August 5, 2011 at 3:35 pm
You bet.
CEWII
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply