In focus

SQL Server Data Tools Preview Update Announced

Microsoft has announced a new update for SSDT Preview, which is now available.

Tahseen Jamil Mar 09, 2016

Microsoft has announced a new update for SSDT Preview, which is now available. 
The company states,
“The SQL Server Data Tools team is pleased to announce an update for SSDT Preview is now available. The SSDT Preview update for Feb 2016 enables SSIS one-designer support for SQL Server 2012 and SQL Server 2014 in Visual Studio 2015. This will allow you to develop with a SQL database, AS, RS and IS project for multiple SQL Server versions with one installation of SSDT in Visual Studio 2015.”
The SQL Server Integration Service comes with the following enhancement:
  • One-designer support for multi-targetting SQL Server 2016 RC0, SQL Server 2014 and SQL Server 2012!
  • SSIS Hadoop connector supports for ORC format
The SQL Server Analysis Service comes with the following enhancement:
  • Support for display folders for Tabular models
  • Any models created with new SQL Server 2016 compatibility level can be used with SSIS. 
Some of the known issues as per the official blog are as stated below: 
  • SQL Server Integration Services
  • SQL 2016 Project connection manager UI is used when switching to 2014.
  • Project connection manager UI uses 2016 UI instead of 2014 UI if you create the project level connection manager in 2014, switch the target server version to SQL server 2016, then switch it back to SQL server 2014.
  • Script component doesn’t work after switching target server version if script fails to build.
  • Debug in 64 bits mode in SSDT for Visual Studio 2015 doesn’t work if target server version is set to SQL server 2012/2014.
  • Script editor in Visual Studio 2013 may crash when SSDT-BI for Visual Studio 2013 and SSDT for Visual Studio 2015 are installed on the same machine.
The following are the steps for set up:
  • If a version of SQL Server 2016 CTP is already installed on the machine, setup may be blocked. This is to avoid breaking components shared by the engine.
  • If installing SSMS Preview, SSDT Preview for Visual Studio 2015, or SSDT Preview for Visual Studio 2013 side by side on the same machine, there may be issues unless all are updated to the latest release.
  • (VS2015) .Net 4.6.1 may not install if there is no version of Visual Studio or the VS Integrated Shell previously installed on the machine. .Net 4.6 will be installed instead.
  • This will result in no Network connections being shown in the new connection dialog.
  • Recommendation is to install .Net 4.6.1 as it contains a number of stability improvements and SQL related fixes.
  • (VS2015) The April 2014 update to Windows 8.1 and Windows Server 2012 R2 Known as KB2919355 is required to install the Visual Studio 2015 Isolated Shell. Please install KB 2919355 before you install SSDT on these operating systems.
  • (VS2015) The SSDT Japanese language installer may fail on the first attempt due to an issue installing the Visual Studio 2015 Japanese language pack. Retrying installation should succeed in installing correctly.
For more details check the official blog.

Tahseen Jamil
Tahseen Jamil

I am a freelance writer for the past 3 and half years. I aspire to generate interesting and productive ideas to the readers through my writing. My objective is to share information with the readers and inform them about ... Read more