This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 4%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
I have a pipeline which has Lookup activity and the output of the lookup activity will be a stored procedure name.
In the for each loop, I am executing the stored procedures one by one using Stored Procedure activity.
Now the requirement is , I have to execute the procedures simultaneously (Parallel execution) in side the foreach loop.
Kindly advise how to implement the above requirement.
Don't tick the sequential property, this way it runs all inner activities (stored procedure) in parallel. Have you tried it already?
----------
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Thanks a lot for the response VaibhavChaudhari . Yes I tried it already. Let me explain you the flow.
I have a control table where I will insert all the Stored procedure names. Using lookup activity am fetching the sp name and sending it to For each loop to iterate. so this is not working as expected
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 9%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hi @Somu, Darthick ,
I tried the approach suggested by anonymous userChaudhari and it is working fine. Below is the snapshot of the approach, please adjust Batch count setting accordingly, default is 20. Please refer this document for additional details.
Let us know for any further queries and we will be glad to assist.
Hi @Somu, Darthick ,
We have not received a response from you. Please suggest if above suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Hi @Somu, Darthick ,
We still have not heard back from you. Following up to check if suggested approach is helpful. Otherwise, let us know and we will continue to engage with you on the query.
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Hi All,
Thanks for the inputs. Yes, the solution given by Vaibhav was working. The only thing is that , I couldn't have many tasks inside the for each loop. Now we have designed in such a way that only SP activity is used inside the Loop.
so that it is working as expected.