SSIS - Expression



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

Ssis Expression Precedence Constraint


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.


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


Documentation / Reference

Discover More
SSIS - Package

A package defines a workflow of tasks to be executed An unit of task flow execution An unit of deployment (package deployment model) You can execute each package independently, and you can also use...

Share this page:
Follow us:
Task Runner