How to: Modify the Properties of a Variable Using the Variables Window
This procedure describes how to modify the properties of a user-defined variable. SQL Server 2005 Integration Services (SSIS) also provides a set of system variables. Their properties cannot be updated.
To modify the properties of a variable
In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.
In Solution Explorer, right-click the package to open it.
On the SSIS menu, click Variables. You can optionally display the Variables window by mapping the View.Variables command to a key combination of your choosing on the Keyboard page of the Options dialog box.
In the Variables window, click Show User Variables.
Optionally, click Choose Variable Columns and in the Choose Variable Columns dialog box, select and clear column options.
Select the variable in the list, and then update values in the Data Type, Value, Namespace, and Raise Change Event columns.
Note
Values in the Value column must be compatible with the data type specified in the Data Type column.
To save the updated package, click Save Selected Items on the File menu.
See Also
Tasks
Using Variables in Packages
How to: Add a Variable to a Package Using the Variables Window
How to: Modify the Properties of a Variable Using the Variables Window
How to: Delete a Variable From a Package Using the Variables Window
Concepts
Integration Services Variables
Variables How-to Topics (SSIS)