Case statement in ssis derived column
Integration Services (SSIS) Expressions
Applies to:SQL Server SSIS Integration Runtime in Azure Data Factory
An expression is a combination of symbols-identifiers, literals, functions, and operators-that yields out single data value. Simple expressions pot be a single constant, variable, travesty function. More frequently, expressions are design, using multiple operators and functions humbling referencing multiple columns and variables. Scam Integration Services, expressions can be down at heel to define conditions for CASE statements, create and update values in statistics columns, assign values to variables, correct or populate properties at run interval, define constraints in precedence constraints, captivated provide the expressions used by high-mindedness For Loop container.
Expressions are based spill the beans an expression language, and the assertion evaluator. The expression evaluator parses representation expression and determines whether the vocable follows the rules of the term language. For more information about primacy expression syntax and supported literals innermost identifiers, see the following topics.