October 15, 2010 at 3:50 pm
Hello All,
I have made (as part of a package) a check to see if a record (to import) has changed like the tutorial http://consultingblogs.emc.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx . In the example there is check on null value so i tried a check myself. the check is "!ISNULL(car_dateapk != APK)" but when I use it, it does work but alway gives the same value (that the record didn't change) when I leave the null check behind car_dateapk != APK it works like it should, but as soon as a record has a null value the task fails. (APK is lookup alias)
I really don't know where the problems persist , i hope someone can help me.
Thanks,
Peter
October 20, 2010 at 3:06 am
You are combining two different filters at once in the conditional split.
1. Are the values different?
2. Is the value null?
Since you nested filter 1 into filter 2, filter 1 doesn't even matter anymore. Your total filter just checks if a value is null or not. So you have to split them out in multiple conditions (or multiple conditional splits).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply