How to: Delete a Variable From a Package Using the Variables Window

This procedure describes how to delete a user-defined variable. SQL Server 2005 Integration Services (SSIS) also provides system variables that make system information available at run time, for use in containers such as packages and event handlers. You cannot delete system variables.

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want.

  2. In Solution Explorer, right-click the package to open it.

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

  4. In the Variables window, click Show User Variables.

  5. Select the variable to delete, and then click Delete Variable.

  6. If the Confirm Deletion of Variables dialog box opens, click Yes to confirm.

  7. To save the updated package, click Save Selected Items on the File menu.