CASE statement in SSIS

Question

Hi Friends

I have my data in flat file, Now I'm loading it into table.

Now I have a column in my flat file which has int values. If the value is '1' then I want it to put it in destination table as '1' other wise I want to put it as NULL.

How to do this. 

---

Royal Thomas

Answer 1

I wrote a expression in derived column like this 

[col_name] != "1" ||[col_name] != "13"? [col_name] : "NULL"

but is this the way to pass NULL

---

Royal Thomas

Answer 2

How about this

col_name!= "1" || col_name!= "13" ? col_name: NULL(DT_WSTR, 10)

---

Royal Thomas

Answer 3

Looping for knowledge

---

Thanks