SSIS - data flow task - derived column expression

Question

i have question in data flow task - derived column's with the following expression.

Expression:
(DT_WSTR,50)([ID Type] == "Dummy" || [ID Type] == "" ? "" : [ID No#])

anyone can explain me in text what is the meaning of the above expression in derived column SSIS?

Answer 1

Hi @nononame2021 ,

You may also refer to conditional-ssis-expression for details.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

[ID Type] == "Dummy" || [ID Type] == ""

If column "ID Type" contains "Dummy" or (=||) is an empty string ...

? "" : [ID No#])

Then return an empty string otherwise (= :) the value of column [ID No#]

(DT_WSTR,50)

and cast that result to a wide string (WSTR) of length 50.