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


@[$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.

3.2 - Cast

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


(DT_WSTR,1)@[User::counter]

4 - Documentation / Reference


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap