Configure an Expression activity

  1. Add an Expression activity to the map. See Add an activity.
  2. On the Extended Properties page, click the Configuration tab.
  3. Click Set Variable.

    The Expression Node page appears.

  4. To specify the variable that will hold the calculated value, consume the variable in the Target Variable box.
  5. In the Description box, enter a description for the Expression node.
  6. In the Value box, enter the expression using the String, Date and Math functions as required. You can reuse the expression by copying and pasting it in another expression activity. See the corresponding tables for information about these functions.
  7. Click Save.
    Note Be careful in using literal values in your expression. If a literal value includes a decimal point such as 123.45, the data type is double. If you try to assign this literal to a variable defined as a decimal or in a calculation that expects a decimal, the compilation fails.

    Therefore if you wish to use decimal values in your expression, you should create a variable of type Decimal and store the literal value in the variable.