## Tuesday, January 10, 2012

### 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.