SSIS - data flow task - derived column expression

nononame2021 246 Reputation points
2022-06-09T10:09:13.223+00:00

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?

209806-image.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,859 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 26,056 Reputation points
    2022-06-09T10:54:29.757+00:00

    [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.

  2. ZoeHui-MSFT 18,896 Reputation points
    2022-06-10T01:26:52.407+00:00

    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.