Add Variable
SQL Server 2005
Use the Add Variable dialog box to specify the properties of a new variable.
- Container
-
Select a container in the list. The container defines the scope of the variable. The container can be either the package or an executable in the package.
- Name
-
Type the variable name.
- Namespace
-
Specify the namespace of the variable. By default, user-defined variables are in the User namespace.
- Value type
-
Select a data type.
- Value
-
Type a value. The value must be compatible with the data type specified in the Value type option.
- Read-only
-
Select to make the variable read-only.
Reference
Other UI ReferenceOther Resources
Integration Services VariablesIntegration Services Data Types
Using Variables in Packages