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

Question

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.

Answer 1

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.