Conditional Split Expression

  • 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.

  • 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"

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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