question

MadhusudanReddyMandala-4641 avatar image
0 Votes"
MadhusudanReddyMandala-4641 asked KranthiPakala-MSFT commented

Stored Procedures in ADF

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

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.

0 Votes 0 ·

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.