Conditional Split Expression

• ringovski

  Hall of Fame

  Points: 3521

  More actions

  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.

• Phil Parkin

  SSC Guru

  Points: 246986

  More actions

  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"

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• ringovski

  Hall of Fame

  Points: 3521

  More actions

  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.