Stored Procedures in ADF

Madhusudan Reddy Mandala 1 Reputation point
2021-08-14T15:38:12.677+00:00

How to Set Custom Parameters to Stored procedures in Azure Data Factory Pipeline

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

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,906 Reputation points MVP
    2021-08-15T07:32:08.007+00:00

    Hey,
    The below link might help :
    https://learn.microsoft.com/en-us/answers/questions/31693/how-to-pass-dynamic-parameter-in-store-procedure-u.html

    So the above example is w.r.t stored procedure activities.

    You can also leverage dynamic content to execute SP via lookup activity like:

    exec SPname '@{pipeline.parameter()}' somewhat like this.

    0 comments No comments