Need a little help converting IBI WebFocus nested if-else into SSIS if-else logic. Thanks
IF ABC_Code_1 = 'Y' THEN
(IF ABC_Code_2 = 'N' THEN ZZZ_2
ELSE (IF ABC_Code_3 = 'N' THEN ZZZ_3
ELSE (IF ABC_Code_4 = 'N' THEN ZZZ_4
ELSE (IF ABC_Code_5 = 'N' THEN ZZZ_5 ELSE MISSING)))
)ELSE ZZZ_1