SQL Server 2016 New Features - Part 5 Integration Services

0. Contents

5. Integration Services

5.1 AlwaysOn support (CTP 2.2)

5.1 New ssis_logreader database-level role in the SSIS catalog (CTP 2.3)

5.3 New RuntimeLineage logging level in the SSIS catalog (CTP 2.3)

5.3 New custom logging level in the SSIS catalog (CTP 2.3)

5.5 SSIS projects available in SQL Server Data Tools (CTP 2.3)

5.6 Column names for errors in the data flow (CTP 2.3)

5.7 Support for OData v4 data sources (CTP 2.3)

5.8 Improved experience for project upgrade (CTP 2.3)

5.9 Incremental package deployment (CTP 2.3)

5.10 Data Feed Publishing Components are now part of SSIS (CTP 2.4)

5.11 Balanced Data Distributor transformation is now part of SSIS (CTP 2.4)

5.12 Support for Excel 2013 data sources (CTP 2.4)

5.13 Upgrade blocked when SSISDB belongs to an Availability Group (CTP 3.0)

5.14 Support for Azure Blob Storage in the SQL Server Import and Export Wizard (CTP 3.0)

5.15 Support for the Hadoop file system (HDFS) (CTP 3.0)

5.16 Azure Feature Pack for SSIS released for SQL Server 2016 (CTP 3.0)

5.17 AutoAdjustBufferSize property automatically calculates buffer size for data flow (CTP 3.0)

5.18 Reusable control flow templates (CTP 3.0)

5.19 Improved performance for SSIS Catalog views (CTP 3.1)

5.20 Expanded support for Hadoop and HDFS (CTP 3.2)