You probably need to stage the data in a table, then use T-SQL as Source Component and write CASE statement in T-SQL.

Thomas