Sunday, 16 August 2015

SQL SERVER 2016 SSIS NEW FEATURES / ENHANCEMENTS

SSIS 2016 NEW FEATURES

This topic describes the features that have been added/updated in SQL Server 2016 Integration Services
* AlwaysOn support
* Deploy Packages to Integration Services Server
* Project Upgrade

AlwaysOn support
In SQL Server 2016, SQL Server Integration Services (SSIS) introduces new capabilities that allow you to easily deploy to a centralized SSIS Catalog (i.e. SSISDB user database). In order to provide the high-availability for the SSISDB database and its contents (projects, packages, execution logs, etc.), you can add the SSISDB database (just the same as any other user database) to an AlwaysOn Availability Group. When a failover occurs, one of the secondary nodes automatically becomes the new primary node.

Incremental package deployment
The Incremental Package Deployment feature allows you to deploy one or more packages to an existing or new project without deploying the whole project. You 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. See Deploy Packages to Integration Services Server for details.

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.

Reference : msdn
Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

0 comments:

Post a Comment