CODEWITHSUNDEEP
parametersazure-data-factoryexecute-sql-task
Geezer
Geezer

Reputation: 497

Azure Data Factory Set Parameter with SQL Query

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

Upvotes: 2

Views: 9123

Answers (2)

JeffRamos
JeffRamos

Reputation: 923

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.

OK

No good

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

Set Variable

Pass to Pipeline

Upvotes: 6

Leon Yue
Leon Yue

Reputation: 16401

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.

Upvotes: 1

Related Questions