can we pass output parameter in the ADF stored procedure activity


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

    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:

    Lookup activity reference:

    Script activity reference:.

    Hope this helps.

    If you have questions pls write to us.

    0 comments No comments

0 additional answers

Sort by: Most helpful