SSIS expression similar to case statement

Question

I need to write an expression for derived column. My column name is 'status'. what is the equivalent expression in SSIS for the below condition?

Case when Status Like '%Open%' then 0 when Status like '%Won%' then 1 when status like "%Lost%' then 2 Else 3

Thanks in advance

You have a history of not accepting the answers on your questions. You might want to work on this if you want people on the site to continue helping you. — Tab Alleman, May 19 '16 at 16:16

R. Richards · Accepted Answer · 2016-05-18T18:19:44.820

2

Give this a shot:

FINDSTRING(Status,"Open",1) > 0 ? 0 : (FINDSTRING(Status,"Won",1) > 0 ? 1 : (FINDSTRING(Status,"Lost",1) > 0 ? 2 : 3))

edited May 18 '16 at 18:19

answered May 18 '16 at 15:58

R. Richards

1 Answers1