Passing Parameters in the Execute Pipeline Activity in ADF - URGENT

Mike Kiser 1,531 Reputation points
2020-11-25T16:22:29.097+00:00

Hi All,
All I want to do is pass a parameter from one pipeline to another when using the Execute Pipeline Activity and I don't know why I can't get this to work. Can you please advise? Thanks! Mike Kiser
42763-image.png

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

3 answers

Sort by: Most helpful
  1. Nasreen Akter 10,751 Reputation points
    2020-11-25T20:07:51.673+00:00

    Hi @Mike Kiser ,

    If you want to pass parameters from Parent pipeline to Child pipelines, all you have to do is

    1. add parameters in the parent pipeline
    2. add parameters in the child pipeline
    3. and now pass the parameters from parents to child while selecting the child pipeline (please see the screenshots).

    Please accept the answer if this answer your query and up-vote. Thanks!

    42773-parentpipeline-1.jpg42728-parentpipeline-2.jpg

    5 people found this answer helpful.

  2. Peter Ma 206 Reputation points Microsoft Employee
    2021-04-22T23:17:55.15+00:00

    @HimanshuSinha-msft

    Your answer is awesome, but I have a question which is why there is no parameters option in my ExecutePipeline activity?

    Thanks,
    Peter

    1 person found this answer helpful.

  3. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2020-11-25T23:20:53.607+00:00

    Hello @Mike Kiser ,

    As @NasreenAkter-2040 , pointed out thats the way to go . Just wanted to add that you can pass variable also as the parameter when calling the child item . The below animation should help .

    42813-executepipeline.gif

    Thanks
    Himanshu