Menu
This is a SQL Server Integration Services (SSIS) expressions question (I'm pretty new to it).
I would like to write a switch/case expression in a Derived Column transform - basically the new column can have 5 different possible values, based on the value of an input column. All I got from Google is the (condition) ? (true value) : (false value) technique, but this only provides for two possible values. Does SSIS expressions have a switch/case type expression?
I thought of using sequential Derived Column transforms, or creating a temporary lookup table, but that just seems more complicated that it really should be.
Thanks.
239
The Expression Task creates and evaluates expressions that set variable values at runtime, using the Expression Builder. When you edit the task, the Expression Builder is launched.
== (Equal) (SSIS Expression) - SQL Server Integration Services (SSIS) | Microsoft Learn.
In Integration Services, expressions can be used to define conditions for CASE statements, create and update values in data columns, assign values to variables, update or populate properties at run time, define constraints in precedence constraints, and provide the expressions used by the For Loop container.
I have used the equivalent of a if-elseif-else statement to solve the problem, like this:
(condition1) ? (true value1) : (condition2) ? (true value2) : (false value)
155
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
