New in SQL Server 2016 - SSIS

Below are the new capabilities introduced in SQL Server 2016 (Integration Services):

1. Always On support
2. Deploy Packages to Integration Services Server
3. Project Upgrade

Always On Support:

Always On Support is a disaster-recovery solution that provides an enterprise-level alternative to database mirroring.

In SQL Server 2016, SSIS introduces new capability in order to provide high-availability for the SSISDB database and its contents (projects, packages, execution logs, etc.).

You can add the SSISDB database to an AlwaysOn Availability Group. When a failover occurs, one of the secondary nodes automatically becomes the new primary node.

For more information please refer AlwaysOn for SSIS Catalog (SSISDB).

Incremental Package Deployment:

It will allows you to deploy one or more packages without deploying the whole project.

You can incrementally deploy packages using:

a. Deployment Wizard

b. SSMS (uses Deployment Wizard)

c. Stored procedures

d. Management Object Model (MOM) API

For more information please refer Deploy Packages to Integration Services Server.

Project Upgrade:

When you upgrade your SSIS projects from previous to the current version, the project-level connection managers will continue to work as usual and the package layout/annotations are retained.