Add Variable

Use the Add Variable dialog box to specify the properties of a new variable.

Options

  • 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.

See Also

Reference

Other UI Reference

Other Resources

Integration Services Variables
Integration Services Data Types
Using Variables in Packages

Help and Information

Getting SQL Server 2005 Assistance