How can I setup that my stored procedure start first than other components in pipeline

Catalina García 0 Reputation points

I created a pipeline to copy data from blob to sql database and add a stored procedure component, so I need that first the copy data activity be execute and then the stored procedure.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,990 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 34,536 Reputation points Microsoft Employee

    Hi Catalina García,

    Thank you for posting query in Microsoft Q&A Platform.

    If I understand correctly, in your ADF pipeline you want to run copy activity and then on success of it, want to run store procedure activity. Please correct me if I am wrong.

    To achieve this, you need to use on success conditional flow (green line) from Copy Activity to Stored Procedure activity. Please check below gif.


    Hope this helps. Please let me know if any further queries.

    Please consider hitting Accept Answer button. Accepted answers help community as well.