Using case in my expression in ssis

Question

How to use case in my expression. Can anyone suggest on how to do this .

Answer 1

Hey there, lilly girl try this doc below Or you may refer to https://www.mssqltips.com/sqlservertip/2924/case-statement-functionality-in-sql-server-integration-services-derived-column-transformation/ When selecting data from a database using T-SQL, one can use CASE statements to derive new columns based on data in the database. However, when reading data from files in SQL Server Integration Services (SSIS) there isn't a CASE statement readily available when new columns need to be derived or existing values need to be replaced. You may try with

Field == "TrueCondition1" ? “True” : ( Field == "TrueCondition2" ? “True” : ( Field == "TrueCondition3 " ? “True” : ( Field == "TrueCondition4" ? “True” : “False"  ) ) )

If this helps kindly accept the answer thanks much.

Answer 2

Hi, Please go through below links, you may get help:

https://learn.microsoft.com/en-us/answers/questions/1470821/how-to-use-case-when-in-expression-in-ssis https://stackoverflow.com/questions/1686166/how-to-write-ssis-switch-case-expression Regards,