I have 10 stored procedure with parameters I want to run within a single stored procedure is it possible if yes how to do it if no can I do it with other activity

CodePudding user response：

You need three activities. A lookup activity to get the names of your stored procedures. A ForEach activity to loop over all of your stored procedures in Azure Data Factory. Inside the ForEach activity, you will only have one StoredProcedure activity.