Stored Procedure

The Stored Procedure task allows you to to execute a SQL Server stored procedure as a task.

Selecting the Stored Procedure

Once you have selected the stored procedure task type, navigate to the second page of the form. After selecting the SQL Server Connection and Schema, Loome Integrate will attempt to load the available stored procedures it can run.

You can either type the Stored Procedure’s name manually into the entry or use the selector on the right to pick from a list of options populated from the connection.

stored proc selector

Loome Integrate is not able to execute system level stored procedures.