Azure Data Factory Set Parameter with SQL Query

Question

What is the alternative to SSIS' Execute SQL Task in ADF?

I've created a Pipeline parameter called ExtractDate (i know there isn't a date datatype option so I'm using a string datatype here) that I want to populate with the result of a SQL Query and then pass this into other pipelines.

I might be searching for the wrong terms but there doesn't seem to be many tutorials on how to write a SQL query within dynamic content to populate a paramater.

Any examples would be appreciated

Hi @Geezer, If my answer is helpful for you, you can accept it as answer. This can be beneficial to other community members. Thank you. — Leon Yue, Sep 11 '20 at 01:28

score 5 · Accepted Answer · answered Sep 10 '20 at 21:07

You can make this work using a variable if you are calling one pipeline from within another pipeline, but you can't pass values between pipelines which are peers of one another.

You cannot change a pipeline parameter from within the pipeline.

For the first situation which will work, here are the details...

score 1 · Answer 2 · answered Sep 10 '20 at 01:56

Data Factory has the Stored Procedure activity can help us execute the stored procedure in Azure SQL or SQL Server. Or we also could use Lookup active to get the SQL query result.

When the Azure SQL /SQL Server as the source, Data Factory supports query operation.

But for the pipeline parameter, we only can pass the value form the pipeline parameter to pipeline active, we can't pass or set the value from the inner active result to parameter. That means It's impossible to populate with the result of a SQL Query and then pass this into other pipelines.

Azure Data Factory Set Parameter with SQL Query

2 Answers2