SSIS - Expression

1 - About

Expressions can include variables and parameters, enabling to set values dynamically based on specific run time conditions for numerous elements, including:

3 - Snippet

3.1 - Variable and parameters



  • 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.

3.2 - Cast

Cast the numeric variable counter to a string of one character length:


4 - Documentation / Reference

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap