POWER (SSIS Expressions)
Returns the result of raising a numeric expression to a power. The power parameter must evaluate to an integer.
The numeric_expression and power arguments are cast to the DT_R8 data type before the power is computed. For more information, see Integration Services Data Types.
If numeric_expression evaluates to zero and power is negative, the expression evaluator returns an error and sets the return result to null.
If numeric_expression or power evaluate to indeterminate results, the return result is null.
The power argument can be a fraction. For example, you can use the value 0.5 as the power.