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.
