Follow-On Topics

Related Topics

# Adding a Call Stored Procedure (OLEDB) Task Step

Even though the Call Stored Procedure (OLEDB) tool is found under three different tool categories, they do not affect the functionality of the tool.

To add a new Call Stored Procedure (OLEDB) step to an existing task, do the following:

1. Open the relevant task (for creating new tasks, see Creating a New Task).
2. Either:

|  | Click and drag the Call Stored Procedure (OLEDB) icon from the Task Browser to the task Design area.

|  | Click on the Environment tab in the Task Browser. Right-click on Steps and select New > then either Data Connectors > Call Stored Procedure (OLEDB), Execute > Call Stored Procedure (OLEDB), Input > Call Stored Procedure (OLEDB), or Output > Call Stored Procedure (OLEDB).

|  | From the task's Design tab, right-click on empty space and select New > then either Data Connectors > Call Stored Procedure (OLEDB), Execute > Call Stored Procedure (OLEDB), Input > Call Stored Procedure (OLEDB), or Output > Call Stored Procedure (OLEDB).

3. Enter a Name and Description for the step.
4. Select either a recordset or a document from the drop-downs. You can only select a recordset if an Input step has previously been created for the task.
5. Click on the Main tab, and select an OLEDB provider Connection from the drop-down. This will have been pre-configured through the Global Configuration dialog box.
6. Click Browse and select a procedure from the Procedures Parameters dialog box.
   1. If required, enter values for procedure parameters, or drag and drop columns or variables from the Task Browser dialog box.
7. If the procedure returns a recordset, click on the Recordset tab and select the Columns tab.
8. Click Execute. The Available Parameters dialog box automatically displays if the selected store procedure requires any parameters. After the parameters are provided the stored procedure is executed and a recordset structure is created, if applicable.
9. Click on the Options tab and select the error option required.
10. Click OK to save the new step and close the dialog box. An icon for the Step is displayed in the Task Plan.

Copyright © 2018 Quadrant Software B.V. All rights reserved.