Manually Entering a Stored Procedure Name

Stored procedures names can be manually entered.

Procedure

  1. Select the service task that you want to use to call the database.
  2. On the General tab of the Properties view, type the stored procedure name directly in the Name field in the right-hand pane, using the following format:
    [owner.]stored_procedure_name
    where owner is the name of the database user that owns the stored_procedure_name stored procedure.