Forum Discussion
How to call multiple procedures in sequence or concurrent in Microsoft Fabric Factory
Hi @jlakshminaraya
Thanks for using Fabric Community.
You can achieve the above requirement by using a layout as shown below:
Hope this helps. Please let me know if you have any further queries.Hey,
The variable has the SP names :
dbo.sp1;dbo,sp2
the split function splist this variable into an array which is iterated over the for each.And the item() is basically the iteration value so it would be dbo.sp1 or dbo.sp2 which is passed over within the sp activity.
So the SP activity to execute those SPs.
Thanks NandanHegde for your time and detail explanation.
In step 3, do i need to import all 5 stored procedures inside of "for each" and edit the settings of each procedure?
if yes, stored procedure name on each is SP setting is @item() is final , or something to be enterd?
If No, what is the body of stored procedure you have imported in step?
Thanks,
Lakshmi Narayana
- NandanHegde
Super User
Hey,
The variable has the SP names :
dbo.sp1;dbo,sp2
the split function splist this variable into an array which is iterated over the for each.And the item() is basically the iteration value so it would be dbo.sp1 or dbo.sp2 which is passed over within the sp activity.
So the SP activity to execute those SPs.