Select the service task that you want to use to call the database.
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.