Thead Member since 2016 10 posts
Agilify Automation
Posted: 2 years ago
Last activity: 2 years 2 months ago

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
Share this page LinkedIn