You can use variables to:
Two kinds of variables: user variables and system variables.
To create a variable, SQL Server - Integration Services (SSIS) > SSIS > Variable
You can use parameters to pass values to a project or package at run time. For example, you could use a parameter to specify a database connection string.
Parameters initialization can take place in three places (by order of importance)
Value | Description |
---|---|
Execution value | A value specified for a specific execution of a package. |
Server default value | A default value assigned to the parameter during deployment. |
Design default value | A default value assigned to the parameter in the design environment. |
SSIS supports two kinds of parameter (tow scopes):
Parameters are only supported in the project deployment model. When the legacy deployment model is used, you can set dynamic package properties by using package configurations.
Script variable access:
dts.Variables("count")