The SSIS EXP function is a mathematical function that returns the exponential value of the given numeric expression or number. This article explains how to use the EXP function with an example and the syntax for finding the exponential value is as shown below.
EXP(<<numeric_expression>>)
To demonstrate the EXP function, we use the Product table below, which has 14 records. Please refer to the Derived Column Transformation, Union All Transformation, Built-in Functions, and SQL Server articles in SSIS.
SSIS Exponential Value of a Number
For this EXP function example, let me add a Data Flow Task and double-click on it to enter the Data Flow region. Next, add the OLE DB Source to read data from the above SQL database product table. Please join the OLE DB Source to Derived Column Transformation because it helps to write EXP expressions and create new columns.
Next, double-click on it to open the Derived Column Transformation Editor. Drag and drop the SSIS EXP function to the row cell under the Expression and replace the numeric_expression with the Order column to find the exponential value. Either you can manually delete the complete numeric_expression expression or drag and drop the Estimated column will automatically replace it.
The below SSIS EXP function expressions find the exponential value of the Orders and the Estimated order column.
EXP( [Orders] ) EXP( [Estimated] )
Click OK to close the Editor window.
Drag and drop the Union All Transformation and connect the Derived Column to it. Next, right-click on the connection node and choose the Enable Data Viewer. Please run the SSIS EXP function package to see the exponential value of the numbers in orders and estimated columns.
