Monday, June 9, 2008

CASE Statements Syntax in SSIS

Found the way to write case statements in SSIS. Knew it could be done in the Derived Column transformation but did not know the syntax.
The syntax is: case ? true : false
Eg: Cust_Limit >= LKP_CustomerLimit ? Cust_Limit : LKP_CustomerLimit