I have to do this twice in my SSIS package and I hate long confusing nested if statements.
I have to map text strings to a numeric value:
if 1 then "Apple"
else if 2 then "Orange"
These mappings are not in the database (that would make my life too easy) so I have to do it programatically. Other than using the derived column transform and a long nested if statement ( «boolean_expression» ? «when_true»
: «when_false») is there any way to do this?
View Complete Post