Pipeline - use a SQL script as a source

Copper Contributor

I have a SQL script that queries DataLake storage gen 2 using openrowset.

 

I'd like to copy the output to a table in Azure SQL.

 

Is it possible to reference a saved SQL script query for a source dataset in a pipeline?

1 Reply
Raczej nie.