SSIS - Expression
About
Expressions can include variables and parameters, enabling to set values dynamically based on specific run time conditions for numerous elements, including:
- Properties
- Conditional Split transformation criteria
- Derived Column transformation values
Articles Related
Snippet
Variable and parameters
@[$Project::folderPath]+[@User::fName]
where:
- variable names are prefixed with a @ symbol
- parameter name is prefixed with a $ symbol.
- square brackets are used to enclose identifier names in order to support identifiers with names containing spaces
- @User::fName and Project::folderPath are fully qualified name including the namespace.
Cast
Cast the numeric variable counter to a string of one character length:
(DT_WSTR,1)@[User::counter]