| title | Operators (SSIS Expression) | ||||
|---|---|---|---|---|---|
| description | Operators (SSIS Expression) | ||||
| author | chugugrace | ||||
| ms.author | chugu | ||||
| ms.date | 03/01/2017 | ||||
| ms.service | sql | ||||
| ms.subservice | integration-services | ||||
| ms.topic | concept-article | ||||
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
This section describes the operators the expression language provides and the operator precedence and associativity that the expression evaluator uses.
The following table lists topics about operators in this section.
| Operator | Description |
|---|---|
| Cast (SSIS Expression) | Converts an expression from one data type to a different data type. |
| () (Parentheses) (SSIS Expression) | Identifies the evaluation order of expressions. |
| + (Add) (SSIS) | Adds two numeric expressions. |
| + (Concatenate) (SSIS Expression) | Concatenates two expressions. |
| - (Subtract) (SSIS Expression) | Subtracts the second numeric expression from the first one. |
| - (Negate) (SSIS Expression) | Negates a numeric expression. |
| * (Multiply) (SSIS Expression) | Multiplies two numeric expressions. |
| / (Divide) (SSIS Expression) | Divides the first numeric expression by the second one. |
| % (Modulo) (SSIS Expression) | Provides the integer remainder after dividing the first numeric expression by the second one. |
| || (Logical OR) (SSIS Expression) | Performs a logical OR operation. |
| && (Logical AND) (SSIS Expression) | Performs a logical AND operation. |
| ! (Logical NOT) (SSIS Expression) | Negates a Boolean operand. |
| | (Bitwise Inclusive OR) (SSIS Expression) | Performs a bitwise OR operation of two integer values. |
| ^ (Bitwise Exclusive OR) (SSIS Expression) | Performs a bitwise exclusive OR operation of two integer values. |
| & (Bitwise AND) (SSIS Expression) | Performs a bitwise AND operation of two integer values. |
| ~ (Bitwise NOT) (SSIS Expression) | Performs a bitwise negation of an integer. |
| == (Equal) (SSIS Expression) | Performs a comparison to determine if two expressions are equal. |
| != (Unequal) (SSIS Expression) | Performs a comparison to determine if two expressions are not equal. |
| > (Greater Than) (SSIS Expression) | Performs a comparison to determine if the first expression is greater than the second one. |
| < (Less Than) (SSIS Expression) | Performs a comparison to determine if the first expression is less than the second one. |
| >= (Greater Than or Equal To) (SSIS Expression) | Performs a comparison to determine if the first expression is greater than or equal to the second one. |
| <= (Less Than or Equal To) (SSIS Expression) | Performs a comparison to determine if the first expression is less than or equal to the second one. |
| ? : (Conditional) (SSIS Expression) | Returns one of two expressions based on the evaluation of a Boolean expression. |
For information about the placement of each operator in the precedence hierarchy, see Operator Precedence and Associativity.
Functions (SSIS Expression)
Examples of Advanced Integration Services Expressions
Integration Services (SSIS) Expressions