How to run SQL Script in Azure Data Factory v2?

azure azure-data-factory-2
alvipeo picture alvipeo · Jul 2, 2018 · Viewed 12.3k times · Source

There is NO Sql Script activity in Azure Data Factory V2. So how can I create a stored proc, a schema in a database? What are my options?

Answer

SouravA picture SouravA · Dec 20, 2019

I agree that the absence of something like "Execute SQL task" is SSIS is bumming. I normally use a "LookUp" activity as I don't like to create procedures for simple tasks which could be a one line command. The only constraint of lookup activity is that it needs some sort of output result set. So what I do when I need to run an update statement is something like this:

enter image description here

The dummy query select 0 id "feeds" the data to the Lookup activity and thus it is able to run the command set on database.

Related questions

Azure Data Factory v2 using utcnow() as a pipeline parameter

For context, I currently have a Data Factory v2 pipeline with a ForEach Activity that calls a Copy activity. The Copy Activity simply copies data from an FTP server to a blob storage container. Here is the pipeline json file : { "…

Read More
How to read files with .xlsx and .xls extension in Azure data factory?

I am trying to read and excel file in Azure Blob Storage with .xlsx extension in my azure data factory dataset. it throws following error Error found when processing 'Csv/Tsv Format Text' source 'Filename.xlsx' with row number 3: found …

Read More
how to export pipeline in datafactory v2 or migrate to another

I'm trying export one pipeline created in datafactory v2 or migrate to another, but not found the option, Could you help me please

Read More