Passing Parameters in the Execute Pipeline Activity in ADF - URGENT

Mike Kiser 1,536 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.
11,624 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Nasreen Akter 10,811 Reputation points Volunteer Moderator
    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 216 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

    2 people found this answer helpful.

  3. HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator
    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


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.