Changelog for SQL Server Data Tools (SSDT)

This change log is for SQL Server Data Tools (SSDT) for Visual Studio 2015.

For detailed posts about what’s new and changed, please visit the SSDT Team blog

SSDT 17.1

Build number: 14.0.61705.170

What's New?

AS projects:

  • Users can set encoding hints on columns in the UI on 1400 models
  • Non-model-related IntelliSense is now available in offline mode
  • Tabular Model Explorer now contains a node to represent named M expressions available across the model (1400 compat-level tabular models)
  • Azure Active Directory People Picker similar to Microsoft Azure Portal's IAM now available when setting up Role Members in Tabular Models

Database projects:

  • Updated to DacFx 17.1

Bug Fixes

  • Fixed an issue where the Business Intelligence Designers group name was displayed incorrectly in Visual Studio Options in VS2017
  • Fixed an issue where a crash could occur generating a Code Map for a solution with a Report Project or AS Project
  • Fixed a number of issues with PowerQuery integration for Analysis Services 1400 compat-level tabular models
  • Fixed an issue in the new DAX editor tool window where the assignment operator could not be on a separate line when defining a measure
  • Fixed an issue that prevented the tabular measure display from updating when renaming measures in perspective
  • Updated Analysis Services integrated workspace engine and Tabular Object Model that fixes a regression that caused 1200 tabular projects containing translations to fail on deploy to SQL Server 2016 Analysis Services server
  • Fixed a performance issue that made creation\deletion of new 1400 tabular data sources very slow
  • Fixed an issue where the DSV diagram in multi-dimensional models could stop rendering if changing view quickly between different DSVs

DacFx 17.1

  • Fixed an issue when encrypting a column with memory-optimized tables with other identity columns
  • SQLDOM support for CATALOG_COLLATION option for CREATE DATABASE

DacFx 17.0.1

  • Fix for issue with databases with an asymmetric key by an HSM with an EKM provider Connect item

SSDT 17.0 (supports up to SQL Server 2017)

Build number: 14.0.61704.140

What's New?

Database projects:

  • Amending a clustered index on a view will no longer block deployment
  • Schema comparison strings relating to column encryption will use the proper name rather than the instance name.
  • Added a new command line option to SqlPackage: ModelFilePath. This provides an option for advanced users to specify an external model.xml file for import, publishing and scripting operations
  • The DacFx API was extended to support Azure AD Universal Authentication and Multi-factor authentication (MFA)

IS projects:

  • The SSIS OData Source and OData Connection Manager now support connecting to the OData feeds of Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online.
  • SSIS project now supports target server version of "SQL Server 2017"
  • Support for CDC Control Task, CDC Splitter and CDC Source when targeting SQL Server 2017.

AS projects:

  • Analysis Services PowerQuery Integration (1400 compat-level tabular models):
    • DirectQuery is available for SQL Oracle, And Teradata if user has installed 3rd Party drivers
    • Add columns by example in PowerQuery
    • Data access options in 1400 models (model-level properties used by M engine)
      • Enable fast combine (default is false - when set to true, the mashup engine will ignore data source privacy levels when combining data)
      • Enable Legacy Redirects (default is false – when set to true, the mashup engine will follow HTTP redirects that are potentially insecure. For example, a redirect from an HTTPS to an HTTP URI)
      • Return Error Values as Null (default is false – when set to true, cell level errors will be returned as null. When false, an exception will be raised is a cell contains an error)
    • Additional data sources (file data sources) using PowerQuery
      • Excel
      • Text/CSV
      • Xml
      • Json
      • Folder
      • Access Database
      • Azure Blob Storage
    • Localized PowerQuery user interface
  • DAX Editor Tool Window
    • Improved DAX editing experience for measures, calculated columns, and detail-rows expressions, available via the View, Other Windows menu in SSDT
    • Improvements to DAX parser\Intellisense

RS projects:

  • Embeddable RVC Control is now available supporting SSRS 2016

Bug fixes

AS projects:

  • Fixed the template priority for BI Projects so they don’t show up at the top of the New Projects categories in VS
  • Fixed a VS crash that may occur in rare circumstances when SSIS, SSAS or SSRS solution opened
  • Tabular: A variety of enhancements and performance fixes for DAX parsing and the formula bar.
  • Tabular: Tabular Model Explorer will no longer be visible if no SSAS Tabular projects are open.
  • Multi-dimensional: Fixed an issue where the processing dialog was unusable on High-DPI machines.
  • Tabular: Fixed an issue where SSDT faults when opening any BI project when SSMS is already open.Connect Item
  • Tabular: Fixed an issue where hierarchies were not being properly saved to the bim file in an 1103 model.Connect Item
  • Tabular: Fixed an issue where Integrated Workspace mode was allowed on 32-bit machines even though it is not supported.
  • Tabular: Fixed an issue where clicking on anything while in semi-select mode (typing a DAX expression but clicking a measure, for example) could cause crashes.
  • Tabular: Fixed an issue where Deployment Wizard would reset the model's .Name property back to "Model". Connect Item
  • Tabular: Fixed an issue where selecting a heirarchy in TME should display properties even if Diagram View is not selected.
  • Tabular: Fixed an issue where pasting into the DAX Formula bar would paste images or other content instead of text when pasting from certain applications.
  • Tabular: Fixed an issue where some old models in the 1103 couldn't be opened due to presence of measures with a specific definition.
  • Tabular: Fixed an issue where XEvent Sessions could not be deleted.
  • Fixed an issue with attempting to build AS “smproj” files with devenv.com would fail
  • Fixed an issue that was finalizing text changes too frequently when using the Korean IME in AS tabular model sheet tab titles
  • Fixed an issue where the intellisense for DAX Related() function was not working correctly to show columns from other tables
  • Improved AS Tabular project import from database dialog by sorting the list of AS databases
  • Fixed an issue when creating calculated tables in AS tabular model where Tables weren’t listed as suggested objects in the expression
  • Fixed an issue in preview 1400 AS models trying to open using Integrated Workspace server after viewing code
  • Fixed an issue that was preventing some data sources (with no support for initial catalog) from working correctly in certain circumstances
  • Deployment Wizard should apply changes to calculated table partitions even when the option to keep partitions is enabled
  • Fixed an issue where Advanced Properties dialog to existing AS Connection didn’t show full list until reselected
  • Fixed a few issues with clipped UI strings that appeared in some localized builds
  • Fixed a number of issues with PowerQuery integration in 1400 compat-level AS tabular models
  • Fixed an issue with Report Wizard style templates not showing up correctly
  • Fixed an issue with the Report Wizard that could lead to incorrect data source settings when changing from SQL to AS
  • Fixed an issue causing Analysis Services (Tabular) project build failure from command line (devenv.com\exe)
  • Fixed an issue with the DAX measure parser to show highlighted and correct text color when starting with letters before :=
  • Fixed an issue triggering an ObjectRefException if paths got too long attempting to Show All Files for Tabular project in integrated workspace mode
  • Fixed an issue with the Data Source Designer for Compact 4.0 Client Data Provider where it appeared unavailable
  • Fixed an issue that caused an error trying to browse AS mining model in VS2017
  • Fixed an issue in AS multi-dimensional model in VS2017 where DSV diagram stops rendering after changing views and then hits an exception
  • Fixed an issue previewing reports with an AS connection failed in VS2017

RS projects:

  • Fixed an issue when designing reports in SSDT the tree view of parameters, data sources and datasets would collapse when most changes made
  • Fixed an issue where Save should save the version of RDL, not the latest version.
  • Fixed an issue where SSDT RS is backing up files when backup is turned off and several other issues.
  • Fixed an issue in Report Builder where an error would be shown when clicking "Split Cells". Connect Item
  • Fixed an issue where caching could cause incorrect data in a report. Connect Item

IS projects:

  • Fixed an issue that run64bitruntime setting doesn't stick.
  • Fixed an issue that DataViewer doesn't save displayed columns.
  • Fixed an issue that Package Parts hides annotations. Connect Item
  • Fixed an issue that Pacakage Parts discards Data Flow layouts and annotations. Connect Item
  • Fixed an issue that SSDT crashes when importing project from sql server.
  • Fixed an issue with Hadoop File System Task TimeoutInMinutes default to 10 after opening saved SSIS package and at runtime.

Database projects:

  • SSDT DACPAC deploy add setting back in for IgnoreColumnOrder Connect item
  • SSDT failing to compile if STRING_SPLIT is used Connect item
  • Fix issue where DeploymentContributors have access to the public model but the backing schema has not been initialized Github issue
  • DacFx temporal fix for FILEGROUP placement
  • Fix for "Unresolved Reference" error for external synonyms.
  • Always Encrypted: Online encryption does not disable change tracking on cancellation and does not work properly if change tracking has not been cleaned prior to start encryption

SSDT 16.5 (supports up to SQL Server 2016)

Released: October 20, 2016

Build number: 14.0.61021.0

What's New?

Connection Improvements

  • The new search box in the Browse tab helps you filter your Local servers, Network servers, and Azure SQL databases. This is useful if you have a large number of servers or databases appearing in these lists.
  • The History tab has right-click menu options to pin / unpin favorites, and a new option to remove connections from history.

SqlPackage and DacFx API Improvements

Using SqlPackage.exe and the DacFx APIs you can now generate a deployment report, deployment script, and publish to a database all in one action. This is a timesaver for anyone who likes to keep a report of what was published during a deployment. Another benefit is that for Azure scenarios, separate scripts for the master database and the deploy target database are created. Up to now a single script was created which was not useful for repeated deployments.

For SqlPackage’s Publish and Script actions, two new arguments have been added.

  • DeployScriptPath (shortname: dsp). This is an optional path to write the deployment script to. For Azure deployment, if there were TSQL commands to create of modify the DB a master script will be written to the same path but with “Filename_Master.sql” as the output file name.
  • DeployReportPath (shortname: drp). This is an optional path to write the deployment report to.

Note that for the Script action, either the existing Output Path arguments or the new script/report-specific arguments should be used, but not both.

Sample usage:

Publish Action

Sqlpackage.exe /a:Publish /tsn:(localdb)\ProjectsV13 /tdn:MyDatabase /deployscriptpath:”My\DeployScript.sql” /deployreportpath:”My\DeployReport.xml”

Script Action

Sqlpackage.exe /a:Script /tsn:(localdb)\ProjectsV13 /tdn:MyDatabase /deployscriptpath:”My\DeployScript.sql” /deployreportpath:”My\DeployReport.xml”

In DacFx, two new APIs have been added: DacServices.Publish() and DacServices.Script(). These also support performing publish + script + report actions in a single operation. Sample usage:

DacServices service = new DacServices(connectionString);
using(DacPackage package = DacPackage.Load(@"C:\My\db.dacpac")) {
var options = new PublishOptions() {
    GenerateDeploymentScript = true, // Should a deployment script be created?
    GenerateDeploymentReport = true, // Should an xml deploy report be created?
    DatabaseScriptPath = @"C:\My\OutputScript.sql", // optional path to save script to
    MasterDbScriptPath = @"C:\My\OutputScript_Master.sql", // optional path to save master script to
    DeployOptions = new DacDeployOptions()
};

// Call publish and receive deployment script & report in the results
PublishResult result = service.Publish(package, "TargetDb", options);
Console.WriteLine(result.DatabaseScript);
Console.WriteLine(result.MasterDbScript);
Console.WriteLine(result.DeploymentReport);

// Call script and receive deployment script & report in results
result = service.Script(package, "TargetDb", options);
Console.WriteLine(result.DatabaseScript);
Console.WriteLine(result.MasterDbScript);
Console.WriteLine(result.DeploymentReport);

Analysis Services & Reporting Services

SSAS tabular designer DAX parser has improved performance when working with large DAX expressions. For more information, please read the Analysis Services blog post.

Fixed / Improved this month

Database Tools

  • Connect bug 3055711 – Columns cannot be selected from CROSS APPLY OPENJSON with explicit schema
  • Fixed – issue with Auto-generated History table indexes, where DacFx dropped index on redeployment
  • Fixed – issue with DacFx batch parser not parsing escaped bracket ‘]’ characters, which caused publish to fail
  • Improved – SqlPackage now includes descriptions for each action in the help output
  • Fixed – The “Remember Password” option in the connection dialog was not being preserved when editing Advanced options and when editing a connection string saved in Publish, Schema Compare and other files
  • Fixed – For connections show in the History tab with IntegratedAuthentication=true, the Authentication field in connection properties was left blank. This now shows “Windows Authentication” as expected
  • Fixed – Changes to the SQL Server Tools Intellisense settings under Tools -> Options -> Text Editor were not being preserved
  • Improved – the Pin/Unpin button in the connection dialog History tab is now more compact, reducing the likelihood of a scrollbar appearing
  • Fixed – several accessibility issues in the connection dialog were fixed.

Analysis Services & Reporting Services

  • Fixed an issue in SSDT AS tabular designer where clicking the scrollbar thumb in data grid crashed in certain situations
  • Fixed an issue where option to impersonate connection as current user in SSDT AS tabular wasn’t available
  • Fixed an issue in SSDT AS tabular designer where expanding the formula bar too far could make the project unable to re-open
  • Fixed a crash in SSDT AS tabular designer that would occur on key down if table tab was selected
  • Fixed an issue in SSDT AS projects where Analyze in Excel would not connect to down-level AS server versions

Integration Service

  • Fixed Connect bug 1608896: Move Multiple Integration Service Package Tasks

SSDT 16.4 (for SQL Server 2016)

Released: September 20, 2016

Build number: 14.0.60918

What's New?

Schema Compare is now supported in SqlPackage.exe and the Data-Tier Application Framework (DacFx) API. For details, see Schema Compare in SqlPackage and the Data-Tier Application Framework.

Analysis Services – Integrated Workspace Mode for SSDT Tabular (SSAS)

SSDT Tabular now includes an internal SSAS instance, which SSDT Tabular starts automatically in the background if integrated workspace mode is enabled so that you can add and view tables, columns, and data in the model designer without having to provide an external workspace server instance. Integrated workspace mode does not change how SSDT Tabular works with a workspace server and database. What changes is where SSDT Tabular hosts the workspace database. To enable integrated workspace mode, select the Integrated Workspace option in the Tabular Model Designer dialog box displayed when creating a new tabular project. For existing tabular projects that currently use an explicit workspace server, you can switch to integrated workspace mode by setting the Integrated Workspace Mode parameter to True in the Properties window, which is displayed when you select the Model.bim file in Solution Explorer. For details, see the Analysis Services blog post.

Updates and fixes Database tools:

Analysis Services & Reporting Services

  • Fixed an issue in SSDT where error tip pop-ups were in the way when editing DAX for DirectQuery calculated columns.
  • Fixed an issue in SSDT AS tabular grid where the KPI icon wasn't showing in measure grid when Windows scaling factor set at high-DPI 200%+.
  • Fixed an issue in SSDT AS where pasting large table data could make the tabular project unresponsive.
  • Fixed an issue in SSDT AS tabular model editor to mark the model as needing to save changes when renaming connection friendly name.
  • Fixed an issue in the SSDT AS tabular projects where width of columns in the manage relationships dialog could not be resized.
  • Fixed an issue in SSDT AS tabular 1200-level models where pasting data from Excel with locale settings like German didn't treat the comma as the decimal separator correctly.
  • Fixed an issue in SSDT AS projects with some KPI icon sets which could yield an error "Couldn't retrieve the data for this visual".
  • Fixed an issue with SSDT AS project properties dialog to anchored correctly when resized at High-DPI scaling.
  • Fixed an issue in SSDT AS projects that may have caused an error upgrading certain models with Pasted tables.
  • Fixed an issue in SSDT AS where pasting full sheet rows from Excel was very slow and created many unwanted columns.
  • Fixed an issue in SSDT AS where large static DataTable expressions parsing and highlight was really slow or appeared to hang.
  • Fixed an issue in SSDT AS to add measures and KPI values to the current perspective selected in the editor.
  • Fixed an issue in SSDT where data import into AS project from SQL Azure didn't support schema types other than "dbo".

SSDT 16.3 (for SQL Server 2016)

Released: August 15, 2016

Build number: 14.0.60812.0

What's New?

  • Release Versioning & Numbering: Releases are now tagged numerically rather than by month. This aligns with the new SSMS policy and simplifies cases where we have multiple releases or hotfixes in a month. This release is 16.3 which means the third update after the RTM release. Any hotfix will be 16.3.1 and so on, with our next update (planned for next month) being 16.4.
  • Analysis Services – Tabular Model Explorer: Tabular Model Explorer lets you conveniently navigate through the various metadata objects in a model, such as data sources, tables, measures, and relationships. It is implemented as a separate tools window that you can display by opening the View menu in Visual Studio, pointing to Other Windows, and then clicking Tabular Model Explorer. The Tabular Model Explorer appears by default in the Solution Explorer area on a separate tab. Tabular Model Explorer organizes the metadata objects in a tree structure that closely resembles the schema of a tabular 1200 model and many more new features.
  • Database Tools – Always Encrypted: This release provides new Always Encrypted Key management dialogs to easily add Column Master Keys or Column Encryption Keys to your database project, or a live database in SQL Server Object Explorer. This release supports certificates in Windows Certificate Store. In upcoming releases, Azure Key Vault and CNG Providers will be supported.
    • While creating Column Master Key or Column Encryption Key, you may experience that the changes are not reflected on SQL Server Object Explorer immediately after clicking Update Database. To workaround, refresh the database node in SQL Server Object Explorer.
    • If you try to encrypt a column in a table with data from SQL Server Object Explorer, you may experience a failure. This feature is currently supported only in SSDT database projects and SSMS. Support for SQL Server Object Explorer will be enabled in a later release.

Updates and fixes

  • Database tools:

    • SSDT:
    • DACFx:
      • Fixed an issue where DACFx compatibility level is not updated for SqlAzureV12 error.
      • Fixed an issue where IsAutoGeneratedHistoryTable property is incorrectly excluded from model comparison.
  • Analysis Services & Reporting Services

    • SSDT:
      • Fixed an issue that Tabular model cannot be saved when the server connection is lost.
      • Fixed an issue that SSDT becomes unresponsive due to a possible infinite loop issue in AS.
      • Fixed a DAX expression issue that caused inconsistent behaviors based on how you commit the expression .
      • Fixed a VS crash issue when creating KPIs.
      • Fixed an issue that generated invalid reports for SQL Server 2008 R2, 2012 and 2014.
      • Fixed a Hierarchy order issue that caused an infinite loop error for .dwpro project.
      • Fixed a RS RDL issue where downgrading RDL required a full rebuild which caused user’s confusion.
      • Fixed a KPI issue where Hide From Client Tools had no effect.

SSDT July (for SQL Server 2016)

Released: June 30, 2016

Build number: 14.0.60629.0

What's New?

  • Always Encrypted support: For Databases that contain Always Encrypted columns, this release adds full support for Always Encrypted through our core APIs and command line tool (SqlPackage.exe). You can build and publish database projects with full support for all Always Encrypted features.
  • Temporal Tables enhanced support: Simplified the experience by unlinking temporal tables before alterations and re-linking once these have completed. This means that Temporal Tables have parity with other table types (standard, in-memory) in terms of the operations that are supported.
  • SqlPackage.exe and installation changes: Changes to isolate SSDT from SQL Server engine and SSMS updates. For details, see Changes to SSDT and SqlPackage.exe installation and updates.

Updates and fixes

  • Database tools:

    • From now on SSDT will never disable Transparent Data Encryption (TDE) on a database. Previously since the default encryption option in a project’s database settings was disabled, it would turn off encryption. With this fix encryption can be enabled but never disabled during publish.
    • Increased the retry count and resiliency for Azure SQL DB connections during initial connection.
    • If the default filegroup is not PRIMARY, Import/Publish to to Azure V12 would fail. Now this setting is ignored when publishing.
    • Fixed an issue where when exporting a database with an object with Quoted Identifier on, export validation could fail in some instances.
    • Fixed an issue where the TEXTIMAGE_ON option was incorrectly added for Hekaton table creations where it is not allowed.
    • Fixed an issue where Export took a long time exporting with large amount of data due to a write to the model.xml file after data phase completed caused contents of the .bacpac file to be rewritten.
    • Fixed an issue where Users were not appearing in the Security folder for Azure SQL DW and APS connections.
    • Analysis Services & Reporting Services:
      • Fixed a SxS issue with MSOLAP OLEDB provider where only the 32-bit provider was getting installed, impacting 64-bit Excel 2016 connecting to SQL Server 2014 (did not repro with ClickOnce installs from Office365, only MSI Excel install).
      • Fixed an issue for a corner case to be more robust when upgrading AS model with pasted tables from 1103 to 1200 compat-level that could give error "Relationship uses an invalid column ID".
      • Fixed a SxS issue when SSDT-BI 2013 on same machine, could no longer import data in AS model after uninstalling SSDT 2015 (cartridges shared registry setting).
      • Improved robustness to address issues\crashes when the connection to the AS engine is lost (i.e. SSDT left open overnight and AS server recycled, or other cases where the connection is temporarily lost).
      • Fixed issues with dialogs opening on different screens than VS in multi-monitor scenarios.
      • Fixed/enabled support for pasting from HTML tables (grid data) in AS model pasted tables.
      • Fixed issue where upgrade failed to upgrade an empty pasted table to 1200 (used only as container table for measures).
      • Fixed an issue with upgrading AS tabular model with pasted tables to 1200 to work around an AS engine issue with CalcTables (which are used for Pasted Tables in 1200), to perform a process full on the new calc tables after the upgrade.
      • Fixed an issue where canceling creation of new AS 1200 model calculated table with incomplete DAX expression could crash.
      • Fixed an issue importing 1200 model from AS server into SSDT AS project when DB name and a table name were the same.
      • Fixed an issue with editing KPI measure in 1103 tabular model.
      • Fixed an Object reference not set exception hit while pasting a KPI measure in the grid for an AS 1200 model.
      • Fixed an issue where a column in a calculated table could not be deleted from the diagram view in 1200 models.
      • Fixed an Object Reference not set exception when viewing the model.bim project file properties while in code view.
      • Fixed an issue with pasting data into AS model grid to create pasted table yielded incorrect values on international locales using comma as decimal separator.
      • Fixed an issue opening 2008 RS project in SSDT and choosing to not upgrade it.
      • Fixed issue in 1200 compat-level models calculated table UI when using default formatting for column type to allow changing the formatting type from the UI.

SSDT June (for SQL Server 2016)

Released: June 1, 2016

Build number: 14.0.60525.0

SSDT General Availability (GA) is now released. The SSDT GA update for June 2016 adds support for the latest updates of SQL Server 2016 RTM, and various bug fixes. For details, see SQL Server Data Tools GA update for June 2016.

SSDT April (for SQL Server 2016 RC3)

Released: April 15, 2016

Build number: 14.0.60413.0

SQL Server Database

  • Always Encrypted Support: For Databases that contain Always Encrypted columns, SSDT and DacFx allows viewing and editing these databases and publishing from a database project to them. Note that support for altering columns with column encryption present will be coming in a future release.
  • Connection dialog and SQL Server Object Explorer: Multiple fixes and improvements.
    • The Details page listing advanced connection properties was overhauled to show the full connection string in a multi-line box, and to improve support on High DPI machines.
    • We have brought back the traditional error dialog with detailed connection errors. This helps when diagnosing login issues with clearer error messages and a stack trace so that DBAs or CSS can get the information they need to help diagnose your problems.
    • For users with minimal permissions we fixed a number of issues around listing databases in the Connection Dialog and SQL Server Object Explorer, viewing the Security folder, and more.
    • Azure SQL DB performance when expanding the databases node to list all DBs has been improved.
  • SSDT installer:
    • Fixed issue where .Net was being downloaded on uninstall.
    • The installer size is now set correctly on High DPI machines.
    • Removed the version check blocking SSDT installation if a newer SQL Server version is present.
    • Schema Compare: Fixed a performance issue where checking/unchecking multiple items took a long time in Visual Studio.
    • Support for using LocalDB 2014 on x86 machines, since there is no x86 version of SQL Server 2016.
  • Build and Deployment:
    • Fixed issue where computed columns were not supported on Temporal Tables.
    • The “Execute deployment script in single-user mode” option is ignored when deploying to Azure V12 as this is not supported in cloud scenarios.

SSDT Hotfix (for SQL Server 2016 RC2)

Released: April 5, 2016

Build number: 14.0.60329.0

This build contains a hotfix for the version of SSDT that provides features for SQL Server Integration Services. Build 14.0.60316.0 can also be used with Analysis Services and Reporting Services in SQL Server 2016.

To get this hotfix, use the download links on this blog post.

Report developers, if you build new reports using this build of SSDT, read the known issue and workaround for a for a temporary issue in SSRS reports found only in this hotfix.

SSDT Hotfix (for SQL Server 2016 RC0)

Released: March 18, 2016

Build number: 14.0.60316.0

This build contains a hotfix for the version of SSDT that provides features for SQL Server 2016 RC0. There is no RC1 version of SSDT at this time. Build 14.0.60316.0 can be used with either RC0 or RC1 of SQL Server 2016.

SSDT February 2016 Preview (for SQL Server 2016 RC0)

Released: March 7, 2016

Build number: 14.0.60305.0

  • SQL Server project templates

    No announcements for this SSDT preview release. See What's New in Database Engine to learn about other features in this release.

  • SSIS package project templates

    SSIS Designer creates and maintains packages for SQL Server 2016, 2014, or 2012. New templates renamed as parts. SSIS Hadoop connector supports for ORC format. See What's New in Integration Services for details.

  • SSAS project templates (Tabular model projects)

    This month’s update to Analysis Services delivers support for display folders for Tabular models and any models created with new SQL Server 2016 compatibility level is now supported in SSIS packages. For more information. see What's New in Analysis Services (blog post) for details.

  • SSRS report project templates

    No announcements for this SSDT preview release. See What's New in Reporting Services to learn about other features in this release.

SSDT January 2016 Preview

Released: Feb 4, 2016

Build number: 14.0.60203.0

  • SQL Server project templates

    No announcements for this SSDT preview release. See What's New in Database Engine to learn about other features in this CTP.

  • SSIS package project templates

    Adds support for ODBC source and destination components, a CDC control task,
    a CDC source and splitter component, a Microsoft Connector for SAP BW, and an Integration Services Feature Pack for Azure. See What's New in Integration Services for details.

  • SSAS project templates

    Includes enhancements for Tabular models at 1200 compatibility level, calculated columns and row-level security for models in DirectQuery mode, translations of model metadata, TMSL script execution in the SSIS Analysis Services Execute DDL Task, and numerous bug fixes.
    See What's New in Analysis Services (msdn) or What's New in Analysis Services (blog post) for details.

  • SSRS report project templates

    No announcements for this SSDT preview release. See What's New in Reporting Services to learn about other features in this CTP.

SSDT December 2015 Preview

  • SQL Server project templates include bug fixes for the Connection dialog box, recent history lists, proper use of authentication context set in the connection property when loading a database list.

    • Changed test connection timeout value to 15 seconds.

    • Create an Azure SQL Database server firewall rule if the client IP is not registered when loading a database list.

    • SQL Server 2016 CTP3.2 feature programmability support.

  • SSAS project templates add support for creating calculated tables based on DAX expressions and other objects already defined in the model.

  • SSIS package project template additions include SSIS Hadoop connector support for Avro file format and Kerberos authentication.
    Please note that SSIS designer support for SSIS 2012 and 2014 is not yet included in this update.

SSDT November 2015 Preview

  • SQL Server project templates. Preview of improved connection experience for SQL Server and Azure SQL Database.

  • SSIS package project templates. SSIS catalog performance improvement: The performance for most SSIS catalog views for non-ssis-admin user is improved.

  • SSAS project templates include enhancements for Tabular model projects in Analysis Services. You can use the View Code command to view the model definition in JSON. If you aren't using a full-featured edition Visual Studio 2015, you will need one to get the JSON editor. You can download the Visual Studio Community edition for free.

SSDT October 2015 Preview

  • New project templates for BI (Analysis Services models, Reporting Services reports, and Integration Services packages). All SQL Server project templates are now in one SSDT.

  • New SSIS features including Hadoop connector, control flow template, relaxed max buffer size of data flow task.

  • SQL Server 2016 CTP 3.0 feature support for relational database projects.

  • Various bug fixes in SSIS and support for Windows 7 OS.

SSDT September 2015 Preview

  • Multi-language support is new in this preview.

SSDT August 2015 Preview

  • New standalone Setup.exe program for installing SSDT. You no longer need to use a modified version of SQL Server Setup. This version of SSDT includes a project template for building relational databases deployed to SQL Server or Azure SQL Database.

See Also

Download SQL Server Data Tools (SSDT)
Previous releases of SQL Server Data Tools (SSDT and SSDT-BI)
What's New in Database Engine
What's New in Analysis Services
What's New in Integration Services