Post reply

Conditional Split Expression

  • March 14, 2018 at 4:57 pm

    #336562

    Hi All,
    I am trying to write a simple SSIS conditional split expression on a String column [Total actual daily sales]. If the column is NZD then replace it with space. I believe my syntax is correct but it keeps saying it is not Boolean.


    [Total actual daily sales] == "NZD" ? " " :  [Total actual daily sales]

    Thanks for any assistance.

  • March 14, 2018 at 5:05 pm

    #1983321

    ringovski - Wednesday, March 14, 2018 4:57 PM

    Hi All,
    I am trying to write a simple SSIS conditional split expression on a String column [Total actual daily sales]. If the column is NZD then replace it with space. I believe my syntax is correct but it keeps saying it is not Boolean.


    [Total actual daily sales] == "NZD" ? " " :  [Total actual daily sales]

    Thanks for any assistance.

    Try using just this part:
    [Total actual daily sales] == "NZD"

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • March 14, 2018 at 5:10 pm

    #1983322

    Phil Parkin - Wednesday, March 14, 2018 5:05 PM

    ringovski - Wednesday, March 14, 2018 4:57 PM

    Hi All,
    I am trying to write a simple SSIS conditional split expression on a String column [Total actual daily sales]. If the column is NZD then replace it with space. I believe my syntax is correct but it keeps saying it is not Boolean.


    [Total actual daily sales] == "NZD" ? " " :  [Total actual daily sales]

    Thanks for any assistance.

    Try using just this part:
    [Total actual daily sales] == "NZD"

    Cheers of course, got confused between derived syntax and conditional split.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply