SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory

© Andy Leonard, Kent Bradshaw 2020

A. Leonard, K. BradshawSQL Server Data Automation Through Frameworkshttps://doi.org/10.1007/978-1-4842-6213-9_8

8. Azure-SSIS Integration Runtime

Andy Leonard¹  and Kent Bradshaw²

(1)

Farmville, VA, USA

(2)

Providence Forge, VA, USA

 

The Microsoft Azure-SSIS team has been hard at work reducing the friction between executing SSIS packages on-premises and executing SSIS packages in Azure. Many enterprises execute SSIS packages stored in the file system on-premises. In the past, migrating SSIS packages executed in an on-premises file system meant changing enterprise SSIS storage and execution patterns. With the advent of Azure-SSIS File Share–based execution, executing SSIS packages from files in Azure is no longer an ...