Claus on Code

A data dudes random musings about code, bugs, products, life etc.


Derived column IF expression

I can never remember the SSIS if syntax in the derived column control, so Just so I can remember it myself 🙂

The syntax is like this:

(compare) ? true : false 

So if x equals  5 and y equals 1, then this will return x

(x>y)?x:y



Leave a Reply

Your email address will not be published. Required fields are marked *