azure-data-factory
How To Parameterize Stored Procedures in Azure Data Factory
I have the following hard coded Stored Procedure in Azure Data Factory
Can someone let me know how I can parameterize it? I need to be able select from a range of Stored Procedures.
Solution
You can use script activity task to parameterize the stored procedures as well
You can also use dynamic content in SP activity as well :
examples :
SP activity
Updated:
- Until flag not working with Until activity of ADF and loop keep going
- Azure data factory git mode is empty at my branch while the git repository has code
- Azure DevOps YAML deployment pipeline cannot reference variable group in stage
- How to Create a Empty File using ADF Web API Activity in ADLS GEN2
- Email errors from all activities in ADF at once
- Variables and Parameters in Azure Data Factory?
- Copy most recent txt file based on timestamp in filename
- Data Factory to Snowflake copy task Fails with Failed to open the database error
- Check if a value is within a dynamically created row, if so set a value in another column
- Dynamicly processing multiple excel sheets in a Data Flow activity nested in a ForEach
- How to Delay Azure Data Factory the execution of Pipeline runs
- How to concatenate a parameter?
- ADF Mapping Dataflow passing parameter values
- Azure Data Factory Data Flows - Forcing headers into upper case for mapping
- Adding Keys to key value pairs in ADF JSON Processing
- Azure Data Factory naming convention
- Upsert Option in ADF Copy Activity
- Azure SQL Insert Failure
- in ADF Get excel worksheets from http dataset
- Error when registering data factory integration runtime on windows VM
- ADF Dataflow - How to use expression for not equal elements in the array
- ADF Copy Activity Failing Source REST, SINK SQLMI database. Invalid Column Length from the bcp client error?
- Unable to View / Access Repositories from Azure Data Factory
- How to configure an Activity to continue in Azure Data Factory when an previous Activity is Deactivated
- Power BI Metadata using Azure Data Factory (ADF)
- How to Parameterize a query in Azure Data Factory copy activity
- ADF Mapping Data Flows for varying unknown schemas
- How do I pull the last modified file with data flow in Azure Data Factory?
- ADF - status succeeded but stop
- Azure Data Factory - Null parameter in stored procedure activity