EXP (SSIS Expression)
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
Returns the exponent to base e of a numeric expression. The EXP function complements the action of the LN function and is sometimes referred to as the antilogarithm.
Syntax
EXP(numeric_expression)
Arguments
numeric_expression
Is a valid numeric expression.
Result Types
DT_R8
Remarks
The numeric expression is cast to the DT_R8 data type before the exponent is computed. For more information, see Integration Services Data Types.
The return result is always a positive number.
Expression Examples
These examples apply the EXP function to positive and negative values and to zero.
EXP(74)
Returns 1.373382979540176E+32.
EXP(-27)
Returns 1.879528816539083E-12.
EXP(0)
Returns 1.
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for