SSIS conditional derived column

Question

Hi everybody,

I managed to write this conditional expression in SSIS:

(LEFT([PayerID],1)!="9")?[CheckNumber]: ""

However, what I really want to return is either CheckNumber or NULL and it should be varchar (not unicode) string of 10 characters. I'm not sure how to write the correct SSIS expression to achieve the desired result. Trying to use NULL( of the correct type results in expression shown in red.

Thanks in advance.

Answer 1

UPDATE. Figured this out by using NULL(DT_WSTR) and adding conversion in front to the whole expression.