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

R. Richards R. Richards · Accepted Answer · 2016-05-18T15:58:38

Give this a shot:

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