O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Azure Data Factory and SSIS 

Azure Data Factory (ADF) is a service that orchestrate data integration using different services available in Azure. Like SSIS, it can move data from one location to another. The main differences are the following:

  • SSIS needs a windows machine to run. Even to copy data, the service runs on a windows server. ADF doesn’t needs anything to accomplish copy data tasks since the service runs in Azure
  • SSIS has a rich toolset integrated into it to transform data; the dataflow task. ADF has nothing that come close to it built-in.
  • ADF relies on compute services like HDInsight clusters that can run Hive and Pig scripts to transform data.
  • SSIS can transform data on without leaving the package and, without necessarily staging ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required