Stored Procedures in ADF

Madhusudan Reddy Mandala 1

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

KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2021-08-16T06:05:21.447+00:00

Hi @Madhusudan Reddy Mandala ,

Welcome to Microsoft Q&A forum and thanks for posting your query.

Just checking in to see if the below suggestion from @Nandan Hegde was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thanks
KranthiPakala-MSFT 46,442 Reputation points Microsoft Employee

2021-08-18T17:05:24.61+00:00

Hi @Madhusudan Reddy Mandala ,

We still have not heard back from you. Just wanted to check if the below suggestion from Nandan was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

1 answer

Nandan Hegde 31,511 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.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment