SSIS integration runtime

This runtime is specifically used to execute SSIS in the cloud. This is what we're going to use in the remainder of this chapter. It allows for the creation of an integration catalog in an Azure database, and we can therefore deploy our packages into it.

Once the catalog is created, we can configure the runtime to scale out package execution to multiple workers in Azure. This means that if your package calls can be executed in parallel, they can be executed on different compute services, which increases load performance.

Get Hands-On Data Warehousing with Azure Data Factory 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.