Azure Data Factory Pipeline

RJ 306 Reputation points
2025-02-03T22:29:24.8233333+00:00

Hi there,

This pipeline runs Azure SQL SPs. And wanted to check with you if my connections achieve the below.

SP3,4,5,6 should run only after SP1 and 2 gets completed. Is there a container so its an AND operation?

SP 7 should run only when SP3,4,5,6 have completed running.

Thanks.

User's image

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,213 questions
{count} votes

Accepted answer
  1. Nandan Hegde 34,021 Reputation points MVP
    2025-02-04T02:50:08.69+00:00

    SP3,4,5,6 should run only after SP1 and 2 gets completed :

    Can you confirm whether it should be successful completion of both SPs post which 3,4,5,6 should execute or normal completion ( even if there is a failure) ?

    Similarly SP 7 should run only when SP3,4,5,6 have completed running : do you mean succesfull completion of all SPs or just completion?

    Note : There is no need of any loops,containers. The current placements of activities is also proper only the dependencies between the activities needs to be updated which I can help post your reply on my initial ask


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.