March 14, 2018 at 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.
March 14, 2018 at 5:05 pm
ringovski - Wednesday, March 14, 2018 4:57 PMHi 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
March 14, 2018 at 5:10 pm
Phil Parkin - Wednesday, March 14, 2018 5:05 PMringovski - Wednesday, March 14, 2018 4:57 PMHi 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