How to Set Custom Parameters to Stored procedures in Azure Data Factory Pipeline
How to Set Custom Parameters to Stored procedures in Azure Data Factory Pipeline
Hi @MadhusudanReddyMandala-4641,
Welcome to Microsoft Q&A forum and thanks for posting your query.
Just checking in to see if the below suggestion from @NandanHegde-7720 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
Hi @MadhusudanReddyMandala-4641,
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.
Hey,
The below link might help :
https://docs.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.
6 people are following this question.