I'm working on creating one ADF Pipelines. Purpose of this pipeline is to execute list of store procedures in sequence.
So far I am use following method:
Created a SQL table with list of all store procedures. (Table having following schema : Id,ProcedureName,ProcedureparameterValue)
In ADF pipeline, Use lookup component to get all list of store procedures from above table.
Next use ForEach component , which iterate one by one item from above list.
Inside ForEach activity, Use store procedure component and pass dynamic store procedure name using @Item().ProcedureName.
But I am stuck in pass dynamic parameter. As each store procedure have different parameter name. Can anyone have any idea How we can pass dynamic parameter in Store procedure in ADF?
![9043-adf-sample.png][1]
Note: Currently we assume we have only one parameter in all store procedures. Later on we can extend for more parameters. Also not found Azure Data Factory tag So I use adfs.
Find attached screen shot for pipeline:
[1]: /answers/storage/attachments/9043-adf-sample.png
