Execute SQL Task in ADF
February 25th, 2022 in Azure, Blog, Data Factory, SQL Server, SSIS, SynapseIf you’re new to ADF or Synapse pipelines and looking for a way to execute SQL commands in pipelines, unfortunately there is no equivalent to the Execute SQL Task in SSIS, but I have found some alternatives which work well for me. For something as simple as a SELECT statement where you want to return results to be used later, you can use a Lookup activity: You can then reference the output of this activity in other activities using dynamic…
» Read more