Tyler Head (Thead)
Allied Solutions
Sr BPM Developer
Allied Solutions
Thead Member since 2016 10 posts
Allied Solutions
Posted: June 8, 2018
Last activity: June 27, 2018
Posted: 8 Jun 2018 17:22 EDT
Last activity: 27 Jun 2018 5:15 EDT

Calling Multiple SQL Stored Procedures at once

Currently working with a requirement that needs to execute 18 stored procedures at once. I am calling these in two sets (5 first/13 second) using parallel processes for each set.

At the moment I have 18 SQL connectors each with identical connection strings and the only differences are about 4 sets of unique input parameters across the 18 procedures.

Each SQL execute is followed by a GetTable() call to the corresponding lookup table.

Any recommendations?

***Edited by Moderator Marissa to update platform capability tags***

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.