Export (0) Print Expand All  Integration Services Variables
Variables store values that a SQL Server Integration Services
package and its containers, tasks, and event handlers can use at
run time. The scripts in the Script task and the Script
component can also use variables. The precedence constraints
that sequence tasks and containers into a workflow can use
variables when their constraint definitions include expressions.
You can use variables in Integration Services packages for the
following purposes:    • Updating properties of package elements
at run time. For example, you can dynamically set the number of
concurrent executables that a Foreach Loop container allows.
• Including an in-memory lookup table. For example, a package
can run an Execute SQL task that loads a variable with data
values.    • Loading variables with data values and then using
them to specify a search condition in a WHERE clause. For
example, the script in a Script task can update the value of a
variable that is used by a Trans