What’s New for SSIS 2016 RC0?


Hi all,

The SQL Server 2016 RC0 will be out anytime soon. A preview for the SSIS community here

Below is the specific improvements we added for RC0:

  1. SSIS Hadoop connector now supports ORC format.
  2. SSIS SSDT multi-version support targeting SQL versions 2012, 2014 and 2016 (One Designer)
Below are some SSIS SSDT multi-version support Known issues for RC0:
  1. SQL 2016 Project connection manager UI is used when switching to 2014. Create project level connection manager in 2014, Switch target server version to sql server 2016, then switch back to SQL server 2014, the project connection manager UI is still using 2016 UI where it should have used 2014 UI.
  2. Script component doesn’t work after switching target server version if script fails to build.
  3. Debug in 64 bits mode in SSDT 2015 doesn’t work if target server version is set to SQL server 2012/2014.
  4. Script editor in VS2013 will crash when SSDT-BI 2013 and SSDT 2015 are installed on the same machine 

Comments (3)

  1. ArthurZ says:

    The one designer for several SSIS versions is the best thing of all!

  2. Peter says:

    Agreed – looking forward to one designer for multiple SSIS versions. It would be great to have everyone standardize easily no matter which version we need to target.

  3. Matt Hartman says:

    Great news.  I really appreciate you fixing the issues with Script tasks and putting out multiple version support!

Skip to main content