Hi All I am trying to do a simple thing using Conditional Split Task. But I get this error everytime. [Conditional Split [462]] Error: The expression "ColName1 == "AWM"" on "output "Case 1" (506)" evaluated to NULL, but the "component "Conditional Split" (462)" requires a Boolean results. Modify the error row disposition on the output to treat this result as False (Ignore Failure) or to redirect this row to the error output (Redirect Row). The expression results must be Boolean for a Conditional Split. A NULL expression result is an error. What I wanted to do is. Split the result result set accoring tro data in Colunm "ColName1". and if the data is AWM then pull that row. Currently I haveNO row for ColName1 that has AWM in it. But still if it didn't find any then all the row must go to default. Also, when I give a valid name instead of AWM it works. Please let me know where I am wrong!!!!

May be some columns has null value and this condtion is failing try to add one more condition in the expression which checkes for NULL i.e "ColName1 == "AWM""|| "ColName1 == """

There are no Nulls in that Colunm

Try to add a log file and post the exact error message pls.

I think you will find there are some null values in that column. Try an expression like this (which excludes such rows, using ISNULL, not just an empty string as that is very different)- !ISNULL(ColName1) && ColName1 == "AWM"

A.W.M. wrote: There are no Nulls in that Colunm Yes there is. You'd better use a data viewer or re-look at your data. You have NULLs coming through, guaranteed.In your Conditional Split, you can add at the top of the list of conditions an ISNULL() function call.

Thanks this works for me!akhila