Export (0) Print
Expand All

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.

  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. Optionally, click Choose Variable Columns and in the Choose Variable Columns dialog box, select and clear column options.

  6. Select the variable in the list, and then update values in the Data Type, Value, Namespace, and Raise Change Event columns.

    ms141663.note(en-US,SQL.90).gifNote:
    Values in the Value column must be compatible with the data type specified in the Data Type column.

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

Community Additions

ADD
Show:
© 2014 Microsoft