Posts

Showing posts from July, 2021

Deploy Integration Services (SSIS) Projects and Packages

Image
  Deploy Integration Services (SSIS) Projects and Packages 09/26/2019 31 minutes to read +10 Applies to:   SQL Server (all supported versions)   SSIS Integration Runtime in Azure Data Factory Integration Services supports two deployment models, the project deployment model and the legacy package deployment model. The project deployment model enables you to deploy your projects to the Integration Services server. For more information about the legacy package deployment model, see  Legacy Package Deployment (SSIS) .  Note The project deployment model was introduced in SQL Server 2012 Integration Services (SSIS). With this deployment model, you were not able to deploy one or more packages without deploying the whole project. SQL Server 2016 Integration Services (SSIS) introduced the Incremental Package Deployment feature, which lets you deploy one or more packages without deploying the whole project.  Note This article describes how to deploy SSIS packages in general, and how to deploy pa