| title | Add Variable | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | integration-services | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | d09b5d31-433f-4f7c-8c68-9df3a97785d5 | |
| author | janinezhang | |
| ms.author | janinez | |
| manager | craigg |
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.
Integration Services (SSIS) Variables
Integration Services Data Types
Use Variables in Packages