none
Error in conditional split

    Question

  • [Conditional Split [16]] Error: The expression "(MaskAddressIPNUM != Dest_MaskAddressIPNUM)" on "output "ChangedRow" (141)" evaluated to NULL, but the "component "Conditional Split" (16)" 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.

    In MaskAddressIPNum,I have values llike:

    0
    2334324
    2342354
    3454562
    2343455

    Can anyone let me know were I'm making wrong i the expression: "(MaskAddressIPNUM != Dest_MaskAddressIPNUM)"

     

     

     

    Monday, August 29, 2011 7:04 PM

Answers

  • If one of those two columns is null then the expression won't work.

    You should do something with the ISNULL expression

    You can replace the NULL with a default value:

    ((ISNULL(MaskAddressIPNUM) ? 0 : MaskAddressIPNUM) != (ISNULL(Dest_MaskAddressIPNUM) ? 0 : Dest_MaskAddressIPNUM)) 

    Or you could check if they are not null...


    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

    Monday, August 29, 2011 7:16 PM