sqlsql-serverssisetlderived-column

SSIS Derived column based on input columns

I realize this may be a fundamental question but I'm struggling to understand the syntax behind expressions in derived columns. I have a simple case:

UPDATE [Table]
SET [DerivedColumn] = 1
WHERE NOT([InputColumn] IN ('Approved','Verbally Approved'))

This is my SQL and I'd like to know how this translates in an SSIS derived column or some other method that I'm missing.

Solution

  • You should use conditional to translate this expression, but you should specify the output value if this condition is not met, as an example:

    [InputColumn] != "Approved" && [InputColumn] != "Verbally Approved" ? 1 : 0