how to use CASE or IF in SSIS

All,

what's data flow task works with CASE to IF ?

CASE WHEN .ACTION = 'TER' THEN COL 1 ELSE COL 1 end

Thanks

The Derived Column transformation allows you to do this. This is the operator that you're interested in: http://msdn2.microsoft.com/en-us/library/ms141680.aspx

-Jamie