Changelog for SQL Server Data Tools (SSDT)

THIS TOPIC APPLIES TO: yesSQL ServeryesAzure SQL DatabaseyesAzure SQL Data Warehouse yesParallel Data Warehouse

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

For detailed posts about what's new and changed, see the SSDT Team blog

SSDT for Visual Studio 2017 (15.5.1)

Build number: 14.0.16148.0

What's New?

Visual Studio 2017 (15.5.1) is the same release as version 15.5.0 except for the following bug fixes to the installer:

  1. Fix an issue where the installer hangs on SQL Server Integration Services post install.
  2. Fix an issue where setup fails with the following error message: "The requested metafile operation is not support (0x800707D3)".

In addition to these two bug fixes, the following details for 15.5.0 still apply to 15.5.1

SSDT for Visual Studio 2017 (15.5.0)

Build number: 14.0.16146.0

What's New?

SSDT for Visual Studio 2017 (15.5.0) moves from preview to general availability (GA).


  1. Setup UI is localized.
  2. Replace the icon with a higher quality version.

Integration Services (IS)

  1. Added package validation step in Deployment Wizard when deploying to Azure SSIS IR in ADF, which discovers potential compatibility issues in SSIS packages to execute in Azure SSIS IR. For more info, see Validate SSIS packages deployed to Azure.
  2. SSIS extension is localized.

Bug fixes

Integration Services (IS)

  1. Fixed an issue where the layout of OLEDB and ADO.NET connection manager is corrupt.
  2. Fixed an issue where an assembly not found error is raised when attempting to edit a Dimension Processing Task.

Known issues

Integration Services (IS) SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. This issue only applies to debugging. Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

SSDT 17.4 for Visual Studio 2015

Build number: 14.0.61712.050

What's New?

Analysis Services (AS) projects

  • Added three new options to tabular projects (under Options > Analysis Services Tabular > Data Import):
    • Enable Legacy data sources - allows the user to create older "1200 compatibility mode" data sources in newer compatibility modes.
    • Automatic type detection - when enabled the Query Editor for modern data sources will attempt to detect data types for unstructured queries when they are loaded. If the detection is successful, a new step may be added to the query.
    • Run background analysis - when enabled the Query Editor for modern data sources will run queries against the data source as the queries are loaded in order to analyze the query's output schema.

Integration Services (IS)

  • Added package validation step in Deployment Wizard when deploying to Azure SSIS IR in ADF, which discovers potential compatibility issues in SSIS packages to execute in Azure SSIS IR. For more info, see Validate SSIS packages deployed to Azure.

Bug fixes

Analysis Services (AS) projects:

  • Fixed an issue that could cause an unhandled exception when checking in model changes to TFS.
  • Fixed an issue that could cause an exception when adding table with complex M expression to a 1400 model.
  • Fixed an issue that could cause a crash in Visual Studio when searching metadata in the model diagram view.
  • Fixed an issue with 1400 models that could cause calculated columns to get removed from the table definition when saving changes to partition M queries.
  • Fixed an issue when using Rename Query on 1400 models in the Get Data\Table Editor UI that could freeze while validating compatibility with current data model.
  • Fixed an issue that caused a missing Newtonsoft assembly reference when deploying 1400 model to Azure Analysis Service.
  • Fixed an issue that caused an error importing data through PQ into a 1400 model in certain cases.
  • Fixed a scaling issue in the PowerQuery user interface dialogs that would appear when Windows scaling set.
  • Fixed an issue with renaming roles.
  • Fixed issues with the Project Configurations that may have caused changes to not save\sync properly in some cases.
  • Fixed an issue in the PowerQuery editor that was adding "Change Type" steps automatically.
  • Fixed an issue that caused an error opening the BIM file after switching to\from Integrated Workspace mode.
  • MaxConnections property is now visible for data sources in tabular models.
  • Increased the initial size of the PowerQuery editor window.
  • M Query keywords such as "Source" in the PowerQuery editor will now show as localized.
  • Cache credentials when working with 1400 models and structured data sources to prevent having to enter the same credentials for each table edited.

RS Projects:

  • Fixed an issue that prevented deploying a single report in a multi report project
  • Fixed an issue with Shared Data Sources that may have caused an issue on deployment
  • Fixed an issue that could crash in the Undo manager when switching between code view, design view, and query editor window
  • Fixed an issue that may have caused the parameter pane to disappear after runtime error
  • Fixed an issue with Report Projects that may have caused them to lose source control mappings

Integration Services:

  • Fixed an issue that may have occurred when switching a connection on an Analysis Services Process Task
  • Fixed an issue where some tasks/components are not localized well.
  • Fixed an issue where CDC components break after applying a SQL fix for CDC that adds __$command_id column.

SSDT for Visual Studio 2017 (15.4.0 preview)

Build number: 14.0.16134.0

What's New?

This release provides a standalone web installer for SQL Server Database, Analysis Services, Reporting Services, and Integration Services projects in Visual Studio 2017 15.4 or later.


  • Allow user to set nickname when installing a new SSDT for VS2017 instance.
  • Hide feature selection checkboxes of installer if no VS instance is selected.
  • Refine some messages of installer based on customer feedback.
  • Fix an issue that installer doesn’t support upgrade.


  • Fix an issue that Import/Export Wizard cannot list data source when Azure feature pack is installed.
  • Fix an issue that editing an SSIS Analysis Services Process Task throws an exception while switching connection.
  • Fix an issue that CDC components breaks after applying SQL fix that adds __$command_id column.
  • Fix an issue that 3rd party package can’t be edited and executed when targeting old SQL Server.
  • Fix an issue that Flat File Source configure dialog doesn’t show correctly when double click DTSWizard.exe and select Flat File Source.
  • Fix an issue that a package containing Azure Feature Pack task/component can’t execute when targeting SQL Server 2017.

Known Issues

  • The installer is not localized.
  • SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. This issue only applies to debugging. Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

SSDT 17.3 for Visual Studio 2015

Build number: 14.0.61709.290

What's New?

Analysis Services (AS)

  • Cosmos DB and HDI Spark are enabled in 1400 models.
  • Tabular data source properties.
  • "Blank Query" is now a supported option for creating a new Query in the Query Editor for models at the 1400 compatibility level.
  • The Query Editor for 1400-mode models now allows for saving queries without new tables automatically being processed.

Reporting Services (RS)

  • Projects now prompt on open to upgraded format to support using MSBuild to build and deploy.

Known Issues

Analysis Services (AS)

  • Models of 1400 compatibility level in Direct Query mode that have perspectives fail on querying or discovering metadata.

Reporting Services (RS)

  • New Report Project format does not retain source control binding, and raises an error similar to the message:

    The project file C:\path is not bound to source control, but the solution contains source control binding information in it.

    To work around this issue, click Use solution binding every time the solution is opened.

  • After upgrading your project to the new MSBuild format, save may fail with a message similar to the following:

    "Parameter "unevaluatedValue" cannot be null."

    To work around this issue, please update your Project Configurations and populate the Platform property.

Bug Fixes

Analysis Services (AS)

  • Vastly improved performance when loading tabular model diagram view.
  • Fixed a number of issues to improve PowerQuery integration and experience in 1400-compat level models.
    • Fixed an issue that prevented editing permissions for File sources.
    • Fixed an issue Can't change the source for File sources.
    • Fixed an issue Wrong UI displayed for File sources.
  • Fixed an issue that caused the "JoinOnDate" property to be removed when a "Join on Date" relationship was made inactive.
  • New Query option in Query Builder now allows creating a new blank query.
  • Fixed an issue that caused edits to an existing data source query to not update the model definition of the table in 1400-compat level.
  • Fixed issues with custom context expressions that may have caused exceptions.
  • When importing new table with duplicate name in 1400 tabular models, user is now be notified that there was a name conflict and the name adjusted to be unique.
  • Current User impersonation mode has been removed from models in Import mode, as it is not a supported scenario.
  • PowerQuery integration now supports Options for Additional Data Sources (OData.Feed, Odbc.DataSource, Access.Database, SapBusinessWarehouse.Cubes).
  • PowerQuery Options strings for Data Sources will now correctly show localized text based on client locale.
  • Diagram view now shows newly created columns from M Query Editor in 1400-compat level models.
  • Power Query Editor now gives the option to not import data.
  • Fixed an issue with installing a data cartridge used to import tables from Oracle in multi-dimensional models in VS2017.
  • Fixed an issue that may have led to a crash when mouse cursor leaving the tabular formula bar in rare cases.
  • Fixed an issue in Edit Table Properties dialog where changing the table name incorrectly changed source table name causing an unexpected error.
  • Fixed a crash that could occur in VS2017 when trying to invoke Test Cube Security in the Roles designer Cell Data tab designer in multi-dimensional projects.
  • SSDT: Properties are uneditable for tabular data sources.
  • Fixed an issue that may have caused MSBuild and DevEnv builds to not work correctly in some cases with solution files.
  • Vastly improved performance when committing model changes (DAX edits for measures, calculated columns) when tabular model contains larger metadata
  • Fixed a number of issues with importing data using PowerQuery in 1400-compat level models
    • Import takes a long time after clicking Import and UI shows no status
    • Large list of tables on Navigator view when trying to select tables to import very slow
    • Query Editor poor performance working with list of 35 queries in Query editor view (issue in PBI desktop too)
    • Importing multiple tables disabled toolbar and may never finish in certain situations
    • Model designer appeared disabled and showed no data after import of table using PQ
    • Unselecting "Create new Table" in PQ UI still resulted in a new table being created
    • Folder data source not prompting for credentials
    • Object reference not set exception that may occur trying to get updated credentials on structured data source
    • Opening partition manager with M-expression was very slow
    • Selecting Properties on table in PQ editor didn’t show the properties
  • Improved robustness in Power Query UI integration to catch top-level exceptions and show in Output window
  • Fixed an issue with ChangeSource on structure datasource not persisting changes when context expression
  • Fixed an issue where M expression errors may cause failures to update the model without error message shown
  • Fixed an issue closing SSDT with error "The build must be stopped before the solution can be closed"
  • Fixed an issue where VS may appear to hang when setting wrong impersonation mode in 1400 compat-level model
  • Detail rows property will now only be serialized to JSON when it is not empty (changed from default)
  • Oracle OLEDB driver now available in the list for tabular Direct Query mode
  • Adding M-Expressions in 1400-compat tabular models now appear\refresh in the Tabular Model Explorer (TME)
  • Fixed an issue that caused MSOLAP provider to not show up in VS2017 when trying to import using “Other” datasource in pre-1400 compat level models
  • Fixed an issue where adding a translation through TME may cause issues
  • Fixed an issue in the Object Level Security interface that caused the tab to appear\hide incorrectly in certain cases
  • Fixed an issue where failure could occur attempting to open previously loaded multi-dimensional model using Connect to Database dialog
  • Fixed an issue that caused an error when adding custom assemblies to a multi-dimensional model

Reporting Services (RS)

  • Fixed an issue with compile and build of RDLC in VS 2017

SSDT for Visual Studio 2017 (15.3.0 preview)

Build number: 14.0.16121.0

What's New?

This preview is the first version of SSDT for Visual Studio 2017. This release introduces a standalone web installation experience for SQL Server Database, Analysis Services, Reporting Services, and Integration Services projects in Visual Studio 2017 15.3 or later.

Known Issues

  • The installer is not localized.
  • SSIS is not localized.
  • SSIS Execute Package Task doesn't support debugging when ExecuteOutofProcess is set to True. This issue only applies to debugging. Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
  • For a complete list of changes, see the changelog.
  • SSIS Packages containing 3rd party extensions cannot be switched to target other server versions.

SSDT 17.2 for Visual Studio 2015

Build number: 14.0.61707.300

What's New?

AS projects:

  • Object Level Security can now be configured in the Roles dialog for advanced security in 1400 compatibility level tabular models.
  • New AAD role member selection for users without email addresses in AS Azure models in SSDT AS projects for VS2017.
  • New AS Azure "Always Prompt" project property in SSDT AS tabular projects to customize behavior of ADAL credential caching.

Bug Fixes


  • Updated branding references for SQL Server 2017.

AS projects

  • Significant performance fixes made to improve experience when committing DAX measure changes and other model edits.
  • Fixed a number of issues with Power Query integration in Analysis Services projects using 1400-compatability level tabular models.
  • Fixed an issue in Multi-Dimensional projects in VS2017 only where Design Aggregation designer may fail to load.
  • Fixed an issue when dragging an item in the Analysis Services multi-dimensional DSV diagram that could crash VS 2017.
  • Fixed an issue in AS projects where the Deploy Dialog was not always in the foreground on top of Visual Studio.
  • Removed Analysis Services import from Data Marketplace as data source since the service has been decommissioned.
  • Fixed an issue that left the table designer disabled after Import New Table from existing data source through Tabular Model Explorer.
  • Fixed an issue that may cause Model menu items Import from Datasource/Add Datasource to remain hidden in the wrong context.
  • Improved experience when creating a measure from the Tabular Model Explorer to avoid switching focus back to the column used to create a measure.
  • When switching from integrated workspace in AS tabular projects to explicit workspace server, the old database files are now be cleaned up.
  • Fixed an issue in AS tabular 1400 models projects where the Row Level Security checkbox UI state initially showed as unchecked regardless of actual underlying object state.
  • Fixed a crash that could occur when importing text file or Excel file into 1400-compat mode tabular model using Power Query and unhandled exception thrown.
  • Fixed an issue that could occur with the scrollbar thumb in the DAX formula editing control in AS tabular model designer.
  • Fixed an issue that prevented modifying a PowerQuery mashup data source when it contained a username/password authentication.
  • Fixed an issue that could prevent a data source to connect when additional properties set in connection string.
  • Fixed an issue that could crash VS when multiple AS tabular model projects loaded and closing the second model designer without interacting with anything in the designer first.
  • Fixed an issue where edits made to KPI formatting were not getting persisted in some cases.
  • Fixed an issue with PowerQuery UI that showed the wrong menu checked state for whether the formula bar was shown.
  • Fixed an issue in AS Tabular 1400-compat level projects with PowerQuery data sources that could crash VS when selecting Change Data Source menu from Tabular Model Explorer.
  • Fixed an intermittent issue where loading a 1400 tabular model may show the error 'Could not load file or assembly 'Microsoft.ProBI.MashupLibrary'.

RS projects

  • User preferences for RS Ruler and Parameter box settings selection state is remembered correctly across sessions.

IS projects

  • Fixed an issue where ADO/ADO.NET ForEachLoop Container didn't show correctly
  • Fixed an issue where some tasks/components/wizards are not localized
  • Changed latest TargetServerVersion from "SQL Server vNext" to "SQL Server 2017"

SSDT 17.1 for Visual Studio 2015

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 compatibility 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 compatibility 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

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 for Visual Studio 2015 (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 uses 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 compatibility 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 ignores data source privacy levels when combining data)
      • Enable Legacy Redirects (default is false – when set to true, the mashup engine follows 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 are returned as null. When false, an exception is 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 hierarchy 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 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 compatibility 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 (\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 for Visual Studio 2015 (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);

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

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 Visual Studio 2015 (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 Visual Studio 2015 (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 Visual Studio 2015 (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 compatibility 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 compatibility level models calculated table UI when using default formatting for column type to allow changing the formatting type from the UI.

SSDT June for Visual Studio 2015 (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.

Additional Resources

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