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.