Stored Procedure Action—Setting Properties

The Stored Procedure action is used to execute a stored procedure on a database via OLE DB.

NOTE: Some knowledge of SQL and stored procedures is necessary to set properties for this action.

To set Stored Procedure properties

  1. From the Task Builder Available Actions pane, open the Database folder and double-click the Stored Procedure action or drag it into the Steps pane.

  2. In the Connection string type box, select from the drop-down list. Then enter the properties for your selection:

  3. If you want the user name and password for the database server to be required every time the step runs, select Prompt user for a name and password.

  4. In the Stored procedure box, select the stored procedure.

  5. To enter parameters for the stored procedure, click the Add button and enter the parameters in the Stored Procedure Parameters dialog box.

    After a parameter is entered, it is listed in the Parameters box in the Stored Procedure properties. You can add as many parameters as needed.

    When a parameter is selected on the list, the details are shown on the right. To edit or delete any parameter, select it on the list and click Edit or Delete.

    Click the
    Advanced tab, and enter the properties as follows:

  6. To set the Description tab properties, refer to Description Tab Options.

  7. To set the Error Causes and On Error tab properties, refer to Step Error Handling.

  8. When finished, click OK to save settings and close the properties dialog window.

See Also

About Actions

Adding Task Steps

Execute Stored Procedure Action