can we pass output parameter in the ADF stored procedure activity

2023-05-03T11:21:08.8766667+00:00

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

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

Accepted answer
  1. Suba Balaji 11,196 Reputation points
    2023-05-03T16:58:17.25+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful