can we pass output parameter in the ADF stored procedure activity

Question

My stored procedure has an output parameter but how can i call output parameter in the stored procedure activity in ADF pipeline

Answer 1

Hi @Bommisetty, Rakesh (Hudson IT Consultant)

Thanks for using MS q&a for posting your query. We don't have the ability to use stored procedure activity if the sp has output parameters.

Instead, you can make use of lookup activity or script activity.

Compare all three activities' capabilities: https://techcommunity.microsoft.com/t5/azure-data-factory-blog/execute-sql-statements-using-the-new-script-activity-in-azure/ba-p/3239969

Lookup activity reference: https://youtu.be/vU2ZOIPO_So

Script activity reference:. https://youtu.be/WZS-5MUeOlw

Hope this helps.

If you have questions pls write to us.