© Andy Leonard 2021
A. LeonardBuilding Custom Tasks for SQL Server Integration Serviceshttps://doi.org/10.1007/978-1-4842-6482-9_24

24. Deploying to Azure-SSIS

Andy Leonard1  
(1)
Farmville, VA, USA
 
In the previous chapter, we built an SSIS framework to execute metadata-driven collections of SSIS packages using the Execute Catalog Package Task. In this chapter, we build an instance of the Azure-SSIS integration runtime that installs the Execute Catalog Package Task, and then we migrate the metadata-drive framework from the previous chapter to Azure. To accomplish this goal, we will

  • Provision an Azure SQL Database instance to host the SSISDB database and SSIS Catalog

  • Provision an Azure Data Factory

  • Create and configure the Deployment Container

  • Provision ...

Get Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial