Share via


How to: Update a Property Expression

This procedure describes how to update an existing property expression by using the Expression Builder dialog box.

To update a property expression

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

  2. In Solution Explorer, double-click the package to open it, and then do one of the following:

    • If the item is a task or a loop, double-click it, and then click Expressions in the editor.
    • Right-click the item and then click Properties.
  3. Expand Expressions.

  4. Click the property to edit, and then click its ellipsis (…).

  5. In the Expression Builder dialog box, expand Variables to access system and user-defined variables. Expand Mathematical Functions, String Functions, Date/Time Functions, NULL Functions, Type Casts, and Operators to access the functions, the casts, and the operators that the SSIS expression language provides.

  6. To update an expression, drag variables and functions to the Expression box, or manually update the expression.

  7. Optionally, click Evaluate Expression to view the evaluation result of the updated expression. If the expression is not valid, an alert appears that describes the syntax errors in the expression.

    Note

    Evaluating an expression does not assign the evaluation result to the property.

  8. Click OK.

See Also

Tasks

Using Property Expressions in Packages
How to: Create a Property Expression

Other Resources

Integration Services Expression Reference
Expression How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance