sql-serverssisetlconditional-split

SSIS conditional split - condition setting


It's one of my practice stuff, setting the condition to split the scariness of rollercoasters.
However, it didn't work properly as it did not split the default output which is set as "Not scary".
I think something wrong with my second condition, but cannot figure out how to correct that.

Here is the required condition:

And here is the condition I wrote:

  1. Very scary [Speed ( mph )] > 50
  2. Quite scary Type == "wood" || Design != "sit down"

The result didn't show any "not scary" even when type does not equal to wood or design equals to site down

Please help me out, appreciate that! thank you :)


Solution

  • In general your conditional split looks fine but note that SSIS expressions == operator are case sensitive so you can convert all values to UPPER Case

    Quite scary:        UPPER([Type]) == "WOOD" || UPPER([Design]) != "SIT DOWN"