This example computes the modulus from two numeric variables Sales$ and Month. The variable Sales$ must be enclosed in brackets because the name includes the $ character. For more information, see Identifiers (SSIS).

This example uses the modulo operator to determine if the value of the Value variable is even or odd, and uses the conditional operator to return a string that describes the result. For more information, see ? : (Conditional) (SSIS Expression).