SSIS - data flow task - derived column expression

nononame2021 246 Reputation points

i have question in data flow task - derived column's with the following 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?


SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,859 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 26,056 Reputation points

    [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#]


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

  2. ZoeHui-MSFT 18,896 Reputation points

    Hi @nononame2021 ,

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



    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.

    No comments