How to: Update a Property Expression

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

  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.

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

  8. Click OK.

Community Additions