SSIS 2016 Incremental Package Deployment

In SSIS 2012/2014 with project deployment model, you can only deploy the whole project and not the individual packages in project. This creates problem if you are working on multiple packages, one is ready for deployment and others not ready.

With SSIS 2016 you can deploy a single  package to SSISDB catalog.

To deploy an individual package

Start the deployment wizard

 Right click on project in Visual Studio & Click Deployment.

(Or) Start SQL Server 2016 Deployment Wizard from Start Menu.

In the wizard select “Package Deployment” as deployment model.

Browse to the folder containing the packages.

Select the packages that you want to Deploy.

Click Next.

Enter the Server Name & SSIS Catalog Path.

Click Deploy.

Notes:

You can deploy to any project in SSISDB catalog, not necessarily the project that the SSIS package is part of.

You can deploy to 2014/2012 SSIS DB Catalog.