Microsoft hasn’t make any changes in SQL SERVER 2014 Integration Services but below features are added in SQL SERVER 2016.

Always On Support

The AlwaysOn Availability Groups feature Microsoft has introduced in SQL SERVER 2012 as a high-availability and disaster-recovery solution which provides an enterprise level alternative to database mirroring. A unique set of read-write user databases are setup as part of AlwaysOn Availability Groups are called availability databases. An Availability Group supports a failover environment for these availability databases that fail over together, thus maximizes the availability of a set of user databases for an enterprise.

Microsoft has introduced SSISDB catalog (i.e. SSISDB user database) in SQL SERVER 2012, which is the central point for working with SQL SERVER Integration Services (SSIS) projects that we have deployed to the Integration Services Server. I.e. we set projects and package parameters, configure environment to specify runtime values for packages, execute and troubleshoot packages and manages Integration Servers operations. SQL SERVER Integration Services Projects, Packages, Parameters, environments and operations history are stored in SSISDB catalog. In SQL SERVER 2016, in order to provide high availability for SQL SERVER Integration Services SSISDB database (contains Projects, Packages, Parameters, environments and operations history etc.), we can add the SSISDB Database to the AlwaysOn Availability Groups just like an any other user database. In the event of failover one of the secondary node becomes the primary node.

Incremental Package Deployment

With the help of this new Incremental Package Deployment feature we can deploy one or more package to the existing or new projects without deploying the whole project. We can incrementally deploy packages using: Deployment Wizard, SQL SERVER Management Studio (uses Deployment Wizard), stored procedures, and Management Object Model (MOM) API at this time.

Note: In SQL SERVER 2016, the Incremental Package Deployment feature is not available in SQL SERVER Data Tools for BI (SSDT-BI).

Project Upgrade

When we upgrade our SSIS Projects from previous version to current version, the project-level connection managers will continue to work as normal and the package layout or annotations are retained.