The Stored Procedure task allows you to to execute a SQL Server stored procedure as a task.
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.
Loome Integrate is not able to execute system level stored procedures.