derived column if else

Excel Syntax for IF else statement:

=IF(A=B,C,D)

SSIS Derived Column Syntax
A == B ? C : D


http://www.josefrichberg.com/journal/2009/8/24/if-then-else-statement-in-ssis-derived-columns.html