Operators (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 |
|---|---|
Converts an expression from one data type to a different data type. |
|
Identifies the evaluation order of expressions. |
|
Adds two numeric expressions. |
|
Concatenates two expressions. |
|
Subtracts the second numeric expression from the first one. |
|
Negates a numeric expression. |
|
Multiplies two numeric expressions. |
|
Divides the first numeric expression by the second one. |
|
Provides the integer remainder after dividing the first numeric expression by the second one. |
|
Performs a logical OR operation. |
|
Performs a logical AND operation. |
|
Negates a Boolean operand. |
|
Performs a bitwise OR operation of two integer values. |
|
Performs a bitwise exclusive OR operation of two integer values. |
|
Performs a bitwise AND operation of two integer values. |
|
Performs a bitwise negation of an integer. |
|
Performs a comparison to determine if two expressions are equal. |
|
Performs a comparison to determine if two expressions are not equal. |
|
Performs a comparison to determine if the first expression is greater than the second one. |
|
Performs a comparison to determine if the first expression is less than the second one. |
|
Performs a comparison to determine if the first expression is greater than or equal to the second one. |
|
Performs a comparison to determine if the first expression is less than or equal to the second one. |
|
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.
See Also
Tasks
Concepts
Advanced Integration Services Expressions
Other Resources
Integration Services Expression Concepts
Functions (SSIS)