Conditions in SSIS

Question

Hi,

I am importing an excel file with a few columns. I want to add a derived column that will do something like the following:
iif column1="2" and column3="y" and column4="p" then "Slow" elseif column1="6" and column3="x" and column4="row" then "Fast" else "Medium"
How can i write the above in SSIS?

Thanks

Answer 1

Hi collie
have ur derived column expression as
col1 ==  2 && col3 ==  "y"  && col4 ==  "P"? "SLOW" : col1 ==  6 && col3 ==  "x"  && col4 ==  "row" ? "Fast" : "Medium"
____________________________________________________________
Please mark post/s answered / help pul if they answer ur query - -Kunal

Answer 2

([column1] == "2" &&[column3] == "y" && [column4] =="p") ? "Slow" : (([column1] == "6" && [column3] == "x" && [column4] == "row") ? "Fast" : "Medium" )

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 3

Nitesh has provided the right expressions.

Alternatively to know more about expressions refer here.

---

Thanks, Bharani M - Please mark the post as answered if it answers your question. - Please vote the post as Helpful if you find the post as helpful.