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
No comments
{count} votes

2 answers

Sort by: Most helpful
  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.

    No comments