expressions in CONDITIONAL SPLIT

Posted by INQUISITIVEUSER under Sql Server on 8/30/2011 | Points: 10 | Views : 2964 | Status : [Member] | Replies : 1
I am using conditional split in my SSIS Package.(ISNULL(NEW_COST) == TRUE )&& (TRADE_STATUS="NEW')..Configure error output is Fail Component.but am getting the following error:-

[Conditional Split for NEW status [26278]] Error:
The expression on "output "Success evaluated to NULL,
but the "component "Conditional Split 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.


Posted by: INQUISITIVEUSER on: 8/30/2011 [Member] Starter | Points: 25

Got answer myself..use ISNULL(NEW_COST) == TRUE && (ISNULL(TRADE_STATUS) ? "FALSE" : TRADE_STATUS) == "NEW"..the column used in comparison should not contain NULL

INQUISITIVEUSER, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response