The ability to create and maintain SSIS projects for SQL Server 2012, 20 in SQL Server Data Tools (Visual Studio 2015).
This feature enables you to create tasks that can easily be re-used in other packages.
Configuration of the data flow performance has been improved.
Its easier to detect which columns cause errors in the data flow.
This gives you better control over which events are logged.
The ability to define custom logging levels in the SSIS catalog.
Incremental deployment is possible, as opposed to the project-only deployment of SSIS 20.
SSIS also supports the new Always Encrypted feature.
Better support for AlwaysOn Availability Groups.
But with SQL Server 2016, SSIS is expanded with yet new features and capabilities. SQL Server 2014 didnt bring any new features to Integration Services (SSIS).
0 kommentar(er)
