Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
() (Parentheses) (SSIS Expression)

() (Parentheses) (SSIS Expression)

Identifies the evaluation order of expressions. Expressions enclosed in parentheses have the highest evaluation precedence. Nested expressions enclosed in parentheses are evaluated in inner-to-outer order.

Parentheses are also used to make complex expressions easier to understand.


  (expression)
        

expression

Is any valid expression.

The data type of expression. For more information, see Integration Services Data Types.

This example shows how the use of parenthesis modifies the precedence of operators. The first expression evaluates to 100, whereas the second one evaluates to 31.

(5 + 5) * (4 + 6)
5 + 5 * 4 + 6

Community Additions

ADD
Show:
© 2015 Microsoft