I am importing data from excel sheet by using SSIS package. I have two coloumn as above and i am using data convertion to convert the data to string[DT_STR] and [DT_BOOL] I am using conditional split to split in 4 cases..
The 4th case is to handle the null values in the flag coloumn. how can i handle the null values in the flag coloumn?
I am trying something like [flag] == NULL(DT_BOOL) but my package fails when there is a null or a blank cell in excel sheet. How can i handle those value?
asked Jan 17, 2012 at 01:02 PM in Default
with conditional splits, the order of the cases is very important. if you put in case 4 and just do a ISNULL(Section) in the condition and then move it up to the first case, then it will work.
Just a quick note with your cases in the example, the 3rd case where section name is null will never be checked because the first 2 will take precedence over the last one. If you want the null sections to be moved somewhere else, then move it before the flag checks.
Hope this helps!
EDIT: If you want null flags to be evaluated to FALSE, you can change your data conversion transform to a derived column transform, then you don't need the ISNULL(flag) in the conditional split. Enter the Expression for the Flag as, where F2 is the column name from the spreadsheet
![alt text]: http://ask.sqlservercentral.com//upfiles/Untitled_5.jpg