Skip to content

Opening book details…

About this document

Using Variables in SSIS Packages by soft_bh is a document available to read on EtoBox.

The document discusses using variables in SSIS to pass data between stored procedures. It provides steps to: 1. Create a variable named LastSalesOrderID to store the result of executing a stored procedure that returns the last sales order ID. 2. Configure an Execute SQL task to execute the stored procedure and map the result to the LastSalesOrderID variable. 3. Use the variable in a data flow task by mapping it to a parameter for another stored procedure that retrieves order details, and load the resul

Author
soft_bh
Language
EN