Operators (SSIS Expression)

This post describes which operators you can use within the SSIS expression language.

Operator	Description
Cast (SSIS Expression): Convert SSIS Data Types	Converts an expression from one data type to a different data type.
() (Parentheses) (SSIS Expression)	Identifies the evaluation order of expressions.
+ (Add) (SSIS Expression)	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.