SQL Server Data Tools (SSDT) 发行说明Release notes for SQL Server Data Tools (SSDT)

适用对象:yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

这些发行说明适用于 SQL Server Data Tools (SSDT) for Visual Studio (VS)。These release notes are for SQL Server Data Tools (SSDT) for Visual Studio (VS).

有关新增功能和已更改功能的详细文章,请参阅 SSDT 团队博客For detailed posts about what's new and changed, see the SSDT Team blog.

15.9.1,SSDT for VS 201715.9.1,  SSDT for VS 2017

发布时间:  2019 年 4 月 27 日Released:   April 27, 2019
生成号:  14.0.16191.0Build Number:   14.0.16191.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSISSSIS

新项New item 详细信息Details
修复了在定位到以前的 SQL Server 版本时无法正确保留包部件的问题Fix an issue that package part cannot be correctly persisted when targeting to previous SQL Server version  
修复了在使用包部件时无法将表达式添加到优先约束的问题Fix an issue that cannot add expression to precedence constraint when using package part  
修复了 Power Query 源和连接管理器的“帮助”按钮不链接到正确文档的问题Fix an issue that the “Help” button of Power Query Source & Connection Manager doesn’t link to the correct document  
修复了 VS 帮助窗口中不显示 SSIS 内部版本的问题Fix an issue that SSIS build version is not displayed in VS help window  
为 Ole DB 和平面文件连接管理器添加了属性“ConnectByProxy”,它可以在 Azure-SSIS IR 中使用自承载 IR 启用本地数据访问权限Add the property “ConnectByProxy” for Ole DB and Flat File connection manager, which can enable access on-premise data with Self-hosted IR in Azure-SSIS IR  
修复了 ODBC 组件错误映射 DT_DBDATE 数据类型的问题Fix an issue that ODBC components maps DT_DBDATE data type incorrectly  
为 ADO.NET 和 OLE DB 连接管理器添加了属性“ConnectUsingManagedIdentity”,它启用了托管标识身份验证,可以连接到 Azure-SSIS IR 中的数据源Add the property “ConnectUsingManagedIdentity” for ADO.NET and OLE DB connection manager, which enable managed identity authentication to connect to data source in Azure-SSIS IR  

已知问题Known issues

已知问题Known issue 详细信息Details
当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
版本高于 15.8 的 SSDT for Visual Studio 2017 不支持设计包含 Teradata 源/目标的包。SSDT for Visual Studio 2017 higher than 15.8 doesn't support designing packages that contain Teradata source/destination. 使用 SSDT for Visual Studio 2017 (15.8)。Use SSDT for Visual Studio 2017 (15.8).
当 SSIS 和 SSAS 安装在同一个 Visual Studio 实例上时,Power Query 源可能不支持 OData v4。Power Query Source may not support OData v4 when SSIS and SSAS are installed on the same Visual Studio instance.  
当 SSIS 和 SSAS 安装在同一个 Visual Studio 实例上时,Power Query 源可能不支持使用 ODBC 连接到 Oracle。Power Query Source may not support using ODBC to connect to Oracle when SSIS and SSAS are installed on the same Visual Studio instance.  
未本地化 Power Query 源。Power Query Source is not localized.  
   

15.9.0,SSDT for VS 201715.9.0,  SSDT for VS 2017

发布时间:2019 年 1 月 28 日Released:   January 28, 2019
生成号:14.0.16186.0Build Number:   14.0.16186.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSISSSIS

新项New item 详细信息Details
在 ADF 2017 中为 SSIS 添加了 Power Query 源(预览版)。Add Power Query Source (Preview) for SSIS in ADF 2017.  
重新添加对 SQL Server 2012 的支持。Add back the support for SQL Server 2012.  
为 SQL Server 2019 添加了 Oracle 源和目标。Add Oracle source and destination for SQL Server 2019. 定目标到 SQL Server 2019 的 Oracle 源和目标已由 SSDT 安装。Oracle source and destination targeting SQL Server 2019 have already been installed by SSDT.

若要设计定目标到服务器版本 2017 或更低版本的包,请从 Microsoft 下载网站下载相应的 Oracle 连接器版本,并将它安装在 SSDT 计算机上。To design package targeting server version 2017 or below, please download the corresponding Oracle connector version from Microsoft download site and install it on the SSDT machine.
Attunity 推出的用于 Oracle 的 Microsoft Connector 5.0 版(定目标到 SQL Server 2017)Microsoft Connector Version 5.0 for Oracle by Attunity targeting SQL Server 2017
Attunity 推出的用于 Oracle 的 Microsoft Connector 4.0 版(定目标到 SQL Server 2016)Microsoft Connector Version 4.0 for Oracle by Attunity targeting SQL Server 2016
Attunity 推出的用于 Oracle 的 Microsoft Connector 3.0 版(定目标到 SQL Server 2014)Microsoft Connector Version 3.0 for Oracle by Attunity targeting SQL Server 2014
Attunity 推出的用于 Oracle 的 Microsoft Connector 2.0 版(定目标到 SQL Server 2012)Microsoft Connector Version 2.0 for Oracle by Attunity targeting SQL Server 2012
解决了从早期 SSIS 版本迁移时无法加载脚本任务/组件的问题。Fix an issue that Script Task/Component cannot be loaded when migrating from earlier SSIS versions.  
解决了数据查看器在 Windows 7 SP1 和 Windows 8.1 上无法运行的问题。Fix an issue that data viewer doesn't work on Windows 7 SP1 and Windows 8.1.  
解决了在某些情况下保存包导致 Visual Studio 崩溃的问题。Fix an issue that, in some cases, saving the package causes Visual Studio to crash.  
解决了在某些情况下无法执行包的问题。Fix an issue that, in some cases, the package cannot be executed. 在满足以下两个条件时,就会发生此问题:This problem occurred when both of the following conditions are true:

•   保护级别为 EncryptSensitiveWithPassword。•   Protection level is EncryptSensitiveWithPassword.
•   目标服务器版本低于 SQL Server 2017。•   Target server version is earlier than SQL Server 2017.
修复了 SSDT 中未显示使用默认字体的注释的问题。Fix an issue that annotations with default font are not displayed in SSDT.  
ISDeploymentWizard 支持命令行模式下的 SQL 身份验证、Azure Active Directory 集成身份验证和 Azure Active Directory 密码身份验证。ISDeploymentWizard supports SQL authentication, Azure Active Directory integrated authentication, and Azure Active Directory password authentication in command-line mode.  
   

已知问题Known issues

已知问题Known issue 详细信息Details
当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
版本高于 15.8 的 SSDT for Visual Studio 2017 不支持设计包含 Teradata 源/目标的包。SSDT for Visual Studio 2017 higher than 15.8 doesn't support designing packages that contain Teradata source/destination. 使用 SSDT for Visual Studio 2017 (15.8)。Use SSDT for Visual Studio 2017 (15.8).
当 SSIS 和 SSAS 安装在同一个 Visual Studio 实例上时,Power Query 源可能不支持 OData v4。Power Query Source may not support OData v4 when SSIS and SSAS are installed on the same Visual Studio instance.  
当 SSIS 和 SSAS 安装在同一个 Visual Studio 实例上时,Power Query 源可能不支持使用 ODBC 连接到 Oracle。Power Query Source may not support using ODBC to connect to Oracle when SSIS and SSAS are installed on the same Visual Studio instance.  
未本地化 Power Query 源。Power Query Source is not localized.  
   

15.8.2,SSDT for VS 201715.8.2,  SSDT for VS 2017

发布时间:2018 年 11 月 5 日Released:   November 5, 2018
生成号:14.0.16182.0Build Number:   14.0.16182.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSIS:SSIS:

修复了将包含包(包含脚本任务/平面文件目标)的 SSIS 项目部署到 Azure-SSIS,而导致该包无法在 Azure-SSIS 中执行的问题。Fixed an issue that deploying SSIS project which contains packages containing Script Task/Flat file destination to Azure-SSIS will result in the packages failing to execute in Azure-SSIS.

已知问题:Known issues:

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
  • SSDT for Visual Studio 2017 (15.8.2) 不支持设计包含 Oracle/Teradata 源/目标的包。SSDT for Visual Studio 2017 (15.8.2) doesn't support designing packages that contain Oracle/Teradata source/destination. 使用 SSDT for Visual Studio 2017 (15.8)。Use SSDT for Visual Studio 2017 (15.8).

15.8.1,SSDT for VS 201715.8.1,  SSDT for VS 2017

发布时间:2018 年 9 月 27 日Released:   September 27, 2018
生成号:14.0.16179.0Build number:   14.0.16179.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSIS:SSIS:

  1. 添加对 SQL Server 2019(预览版)SQL Server 2019 preview 的支持。Add support for SQL Server 2019(预览版)SQL Server 2019 preview.
  2. 删除对 SQL Server 2012 的支持。Remove support for SQL Server 2012.

已知问题:Known issues:

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
  • 将包含包(包中包含脚本任务/平面文件目标)的 SSIS 项目部署到 Azure-SSIS 可导致该包无法在 Azure-SSIS 中执行。Deploying SSIS projects that have packages that contain Script Task/Flat file destination to Azure-SSIS will result in the packages failing to execute in Azure-SSIS.
  • SSDT for Visual Studio 2017 (15.8.1) 不支持设计包含 Oracle/Teradata 源/目标的包。SSDT for Visual Studio 2017 (15.8.1) doesn't support designing packages that contain Oracle/Teradata source/destination. 使用 SSDT for Visual Studio 2017 (15.8)。Use SSDT for Visual Studio 2017 (15.8).

15.8,SSDT for VS 201715.8,  SSDT for VS 2017

发布时间:2018 年 9 月 5 日Released:   September 5, 2018
生成号:14.0.16174.0Build number:   14.0.16174.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSIS:SSIS:

  1. VS 15.8 修复了以下回归问题:保存脚本任务/组件会触发编译错误。Fix regression in VS 15.8 that saving Script Task/Component will hit compile error.
  2. VS 15.8 修复了以下回归问题:部署向导无法正常运行。Fix regression in VS 15.8 that deployment wizard doesn't work.
  3. 修复了以下问题:ADO.NET 连接管理器不支持第三方 ADO.NET 提供程序。Fix an issue that ADO.NET connection manager doesn't support 3rd party ADO.NET provider.

安装程序:Installer:

  • 在 Windows 10 上安装 SSDT 时实现中途重新启动。Implement reboot-in-the-middle when installing SSDT on Windows 10.

已知问题:Known issues:

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

15.7.1,SSDT for VS 201715.7.1,  SSDT for VS 2017

发布时间:2018 年 7 月 2 日Released:   July 2, 2018
生成号:14.0.16167.0Build number:   14.0.16167.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSIS:SSIS:

  • 添加对新的 Azure 政府 AAD 颁发机构 (login.microsoftonline.us) 的支持,以便与 AS 任务一起使用。Add support for new Azure Government AAD authority (login.microsoftonline.us) for use with AS Tasks.
  • 修复了当目标服务器版本为 SQL Server 2016 时,AS 处理任务 UI 将显示“找不到方法”的问题。Fix an issue that AS processing task UI will show "Method not found" when target server version is SQLServer2016.
  • 修复了目标服务器版本为 SQL Server 2012 时,无法执行某些管道组件的问题。Fix an issue that some pipeline components cannot be executed when target server version is SQLServer2012.

安装程序:Installer:

  • 筛选 VS 实例列表以排除无法安装 SSDT 的实例。Filter the VS instance list to exclude the instances that cannot install SSDT.

已知问题:Known issues:

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
  • 在 Windows 10 上安装 SSDT 并选择“为 Visual Studio 2017 实例安装新的 SQL Server Data Tools”时,安装将因“不支持所请求的元文件操作”而失败。When installing SSDT on Windows 10 and choosing "Install new SQL Server Data Tools for Visual Studio 2017 instance", the installation will fail on "The requested metafile operation is not supported". 请重启计算机并再次启动 SSDT 安装程序以继续安装。Please reboot the machine and launch SSDT installer again to continue the installation.

15.7.0,SSDT for VS 201715.7.0,  SSDT for VS 2017

发布时间:2018 年 6 月 4 日Released:   June 4, 2018
生成号:14.0.16165.0Build number:   14.0.16165.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSIS:SSIS:

  • 修复“选项”对话框中“Integration Services 设计器”页无法正常显示的问题。Fix an issue that Integration Services Designers page in Options dialog cannot be shown properly.
  • 修复“排序转换编辑器”编辑器中文本显示的亮度比问题。Fix an issue that luminosity ratio issue for text appearing in Sort Transformation Editor editor.
  • 修复尝试编辑组合框时“解决引用”对话框消失的问题。Fix an issue that Resolve References dialog disappears when attempting to edit a combobox.
  • 修复“Hadoop 连接管理器”的 F1 帮助链接不起作用的问题。Fix an issue that F1 help link of Hadoop Connection Manager doesn't work.
  • 修复面向 SQL Server 2016 时位于容器中的脚本任务代码丢失的问题。Fix an issue that script task code will be lost if it's in a container when targeting SQL Server 2016.

安装程序:Installer:

  • 修复在 VS 15.7.2 中安装 SSRS 和 SSIS 之前无法安装 SSAS 的问题。Fix an issue that SSAS cannot be installed before SSRS and SSIS are installed in VS 15.7.2.

已知问题:Known issues:

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

15.6.0,SSDT for VS 201715.6.0,  SSDT for VS 2017

发布时间:2018 年 4 月 10 日Released:   April 10, 2018
生成号:14.0.16162.0Build number:   14.0.16162.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSIS:SSIS:

  • 修复问题:以 SQLServer2016 和 SQLServer2017 为目标时,AS 处理任务不记录任何处理步骤Fix an issue that AS processing task doesn't log any processing steps when targeting to SQLServer2016 and SQLServer2017
  • 修复问题:在 SSDT 中打开具有很长非英文名称的 dtsx 时发生访问冲突Fix an issue that access violation will happen when opening dtsx with very long non-English task names in SSDT
  • 修复问题:ScriptTask 变量列表有时会在任务 UI 中消失Fix an issue that sometimes variable list of ScriptTask will disappear in task UI
  • 修复问题:当包位置为 SQL Server 时,添加现有包的副本失败Fix an issue that adding copy of existing package will fail when the package location is SQL Server
  • 修复问题:访问某个编辑器对话框中的组合框时,焦点会卡住。Fix an issue that focus gets stuck while accessing the combo box in some editor dialog box.
  • 修复问题:切换 VS 主题时背景不更改。Fix an issue that background will not change while switching VS theme.
  • 修复问题:注释和加载标签在深色主题中不可见。Fix an issue that annotation and loading label is invisible in dark theme.
  • 修复问题:SSIS 工具箱禁用项的状态属性定义不正确。Fix an issue that the state property is not defined correctly for SSIS toolbox disabled items.
  • 修复问题:执行 WebServiceTask 始终失败。Fix an issue that it always fails to execute WebServiceTask.
  • 修复问题:如果连接字符串设置为某个变量,且其中包含依赖于项目参数的表达式,包部署会失败。Fix an issue that package deployment will fail if connection string is set to variable having expression dependent on project parameters.

安装程序:Installer:

  • 在隐私免责声明中添加“SQL Server Data Tools 客户体验改善计划”链接。Add the link of "Customer Experience Improvement Program for SQL Server Data Tools" in privacy disclaimer.
  • 修复问题:当选择“安装新的 SQL Server Data Tools for Visual Studio 2017 实例”时会弹出 VS 安装程序窗口Fix an issue that VS installer window will popup when selecting "Install new SQL Server Data Tools for Visual Studio 2017 instance"

已知问题:Known issues:

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

15.5.2,SSDT for VS 201715.5.2,  SSDT for VS 2017

生成号:14.0.16156.0Build number:   14.0.16156.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSISSSIS

  • 修复了 SSAS 和 SSIS 安装到同一 VS 2017 实例时,SSIS 2008 项目迁移会失败的问题。Fix an issue that migrating SSIS 2008 projects will fail when both SSAS and SSIS are installed to the same VS 2017 instance.
  • 修复了 Rdlc 报表设计器和 SSIS 安装到同一 VS 2017 实例时,无法生成 Rdlc 项目的问题。Fix an issue that Rdlc projects cannot be built when both Rdlc report designer and SSIS are installed to same VS 2017 instance.
  • 修复了注释颜色无法更新的问题。Fix an issue that the annotation color can't update.
  • 修复了使用其他语言时,某些字符串在 Hadoop 连接管理器编辑器中截断的问题。Fix an issue that some strings in Hadoop connection manager editor are truncated in other languages.
  • 修复了某些字符串在 OData 连接管理器编辑器中截断的问题。Fix an issue that some strings are truncated in OData connection manager editor.
  • 修复了某些字符串在 Integration Services 导入项目向导窗口中截断的问题。Fix an issue that some strings are truncated in Integration Services import project wizard window.
  • 修复了标题位于 SSIS 工具框信息窗口中的问题。Fix an issue with the title in the SSIS tool box information window.
  • 修复了某些字符串在 Integration Services 部署向导窗口中截断的问题。Fix an issue that some strings are truncated in Integration Services Deployment Wizard window.

安装程序Installer

  • 修复了下载有效负载有时失败,出现错误“系统找不到指定的文件 (0x80070002)”的问题。Fix an issue that sometimes downloading payload will fail with error "The system cannot find the file specified (0x80070002)".

已知问题Known issues

  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

15.5.1,SSDT for VS 201715.5.1,  SSDT for VS 2017

生成号:14.0.16148.0Build number:   14.0.16148.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

除了安装程序的以下 bug 修复以外,Visual Studio 2017 (15.5.1) 与版本 15.5.0 相同: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. 修复安装程序在 SQL Server Integration Services 安装后挂起的问题。Fix an issue where the installer hangs on SQL Server Integration Services post install.
  2. 修复了安装失败后会显示以下错误消息的问题:“不支持请求的元文件操作(0x800707D3)”。Fix an issue where setup fails with the following error message: "The requested metafile operation is not support (0x800707D3)".

除了这两个 bug 修复之外,以下有关 15.5.0 的详细信息也仍适用于 15.5.1In addition to these two bug fixes, the following details for 15.5.0 still apply to 15.5.1

15.5.0,SSDT for VS 201715.5.0,  SSDT for VS 2017

生成号:14.0.16146.0Build number:   14.0.16146.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

SSDT for Visual Studio 2017 (15.5.0) 不再提供预览版,改为提供正式版 (GA)。SSDT for Visual Studio 2017 (15.5.0) moves from preview to general availability (GA).

安装程序Installer

  1. 安装程序 UI 已本地化。Setup UI is localized.
  2. 将图标替换为更高质量的版本。Replace the icon with a higher quality version.

Integration Services (IS)Integration Services (IS)

  1. 在 ADF 中将包部署到 Azure SSIS IR 时,部署向导中添加了包验证步骤,可发现要在 Azure SSIS IR 中执行的 SSIS 包的潜在兼容性问题。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. 有关详细信息,请参阅验证部署到 Azure 的 SSIS 包For more info, see Validate SSIS packages deployed to Azure.
  2. SSIS 扩展已本地化。SSIS extension is localized.

Bug 修复Bug fixes

Integration Services (IS)Integration Services (IS)

  1. 修复了 OLEDB 和 ADO.NET 连接管理器的布局损坏的问题。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) 当 ExecuteOutOfProcess 设置为 True 时,SSIS 执行包任务不支持调试。Integration Services (IS) SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

17.3,SSDT for VS 201517.3,  SSDT for VS 2015

生成号:14.0.61712.050Build number:   14.0.61712.050
SSDT for Visual Studio 2015。SSDT for Visual Studio 2015.

新增功能What's New?

Analysis Services (AS) 项目Analysis Services (AS) projects

  • 向表格项目添加了三个新选项(在“选项”>“Analysis Services 表格”>“数据导入”下):Added three new options to tabular projects (under Options > Analysis Services Tabular > Data Import):
    • 启用旧数据源 - 允许用户在较新的兼容性模式下创建较早的“1200 兼容性模式”数据源。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)Integration Services (IS)

  • 在 ADF 中将包部署到 Azure SSIS IR 时,部署向导中添加了包验证步骤,可发现要在 Azure SSIS IR 中执行的 SSIS 包的潜在兼容性问题。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. 有关详细信息,请参阅验证部署到 Azure 的 SSIS 包For more info, see Validate SSIS packages deployed to Azure.

Bug 修复Bug fixes

Analysis Services (AS) 项目:Analysis Services (AS) projects:

  • 修复了在将模型更改签入到 TFS 时可能导致未经处理的异常的问题。Fixed an issue that could cause an unhandled exception when checking in model changes to TFS.
  • 修复了在将包含复杂 M 表达式的表添加到 1400 模型时可能导致异常的问题。Fixed an issue that could cause an exception when adding table with complex M expression to a 1400 model.
  • 修复了在模型关系图视图中搜索元数据时可能导致 Visual Studio 崩溃的问题。Fixed an issue that could cause a crash in Visual Studio when searching metadata in the model diagram view.
  • 修复了在将更改保存到分区 M 查询时可能导致计算列从表定义中删除的 1400 模型问题。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.
  • 修复了在获取数据\表编辑器 UI 中对 1400 模型使用重命名查询时,UI 可能在验证当前数据模型的兼容性时冻结的问题。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.
  • 修复了在将 1400 模型部署到 Azure Analysis Service 时可能导致缺少 Newtonsoft 程序集引用的问题。Fixed an issue that caused a missing Newtonsoft assembly reference when deploying 1400 model to Azure Analysis Service.
  • 修复了某些情况下导致通过 PQ 将数据导入 1400 模型出错的问题。Fixed an issue that caused an error importing data through PQ into a 1400 model in certain cases.
  • 修复了 Windows 缩放集时可能出现的 PowerQuery 用户界面对话框缩放问题。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.
  • 修复了 PowerQuery 编辑器自动添加“更改类型”步骤的问题。Fixed an issue in the PowerQuery editor that was adding "Change Type" steps automatically.
  • 修复了切换到集成工作区模式/从集成工作区模式切换后导致打开 BIM 文件出错的问题。Fixed an issue that caused an error opening the BIM file after switching to\from Integrated Workspace mode.
  • MaxConnections 属性现对表格模型中的数据源可见。MaxConnections property is now visible for data sources in tabular models.
  • 增大了 PowerQuery 编辑器窗口的初始大小。Increased the initial size of the PowerQuery editor window.
  • 现在,PowerQuery 编辑器中显示的 M 查询关键字(如“源”)已本地化。M Query keywords such as "Source" in the PowerQuery editor will now show as localized.
  • 在使用 1400 模型和结构化数据源时缓存凭据,以避免为每个编辑的表输入相同的凭据。Cache credentials when working with 1400 models and structured data sources to prevent having to enter the same credentials for each table edited.

RS 项目: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:Integration Services:

  • 修复了切换 Analysis 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.
  • 修复了对 CDC 应用 SQL 修复,添加 _$command_id 列后,CDC 组件中断的问题。Fixed an issue where CDC components break after applying a SQL fix for CDC that adds _$command_id column.

15.4.0(预览版),SSDT for VS 201715.4.0 (preview),  SSDT for VS 2017

生成号:14.0.16134.0Build number:   14.0.16134.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

此版本为 Visual Studio 2017 15.4 或更高版本中的 SQL Server 数据库、Analysis Services、Reporting Services 和 Integration Services 项目提供了独立的 Web 安装程序。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.

安装程序Installer

  • 允许用户在安装新的 SSDT for VS 2017 实例时设置昵称。Allow user to set nickname when installing a new SSDT for VS2017 instance.
  • 在未选择任何 VS 实例的情况下会隐藏安装程序的功能选择复选框。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.

SSISSSIS

  • 修复了安装 Azure 功能包后导入/导出向导无法列出数据源的问题。Fix an issue that Import/Export Wizard cannot list data source when Azure feature pack is installed.
  • 修复了切换连接时编辑 SSIS Analysis Services 进程任务会引发异常的问题。Fix an issue that editing an SSIS Analysis Services Process Task throws an exception while switching connection.
  • 修复了在应用添加 __$command_id 列的 SQL 修补程序后 CDC 组件会中断的问题。Fix an issue that CDC components breaks after applying SQL fix that adds __$command_id column.
  • 修复了面向旧版 SQL Server 时无法编辑和执行第三方包的问题。Fix an issue that 3rd party package can't be edited and executed when targeting old SQL Server.
  • 修复了双击 DTSWizard.exe 并选择“平面文件源”时“平面文件源”配置对话框无法正确显示的问题。Fix an issue that Flat File Source configure dialog doesn't show correctly when double click DTSWizard.exe and select Flat File Source.
  • 修复了面向 SQL Server 2017 时包含 Azure 功能包任务/组件的包无法执行的问题。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.
  • 当 ExecuteOutOfProcess 设置为“True”时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.

17.30,SSDT for VS 201517.30,  SSDT for VS 2015

生成号:14.0.61709.290Build number:   14.0.61709.290
SSDT for Visual Studio 2015。SSDT for Visual Studio 2015.

新增功能What's New?

Analysis Services (AS)Analysis Services (AS)

  • 在 1400 个模型中启用了 Cosmos DB 和 HDI Spark。Cosmos DB and HDI Spark are enabled in 1400 models.
  • 表格数据源属性。Tabular data source properties.
  • 现在支持“空白查询”选项,用于在查询编辑器中为 1400 兼容级别的模型创建新查询。"Blank Query" is now a supported option for creating a new Query in the Query Editor for models at the 1400 compatibility level.
  • 1400 模式模型的查询编辑器现在支持保存查询,而系统不会自动处理新的表格。The Query Editor for 1400-mode models now allows for saving queries without new tables automatically being processed.

Reporting Services (RS)Reporting Services (RS)

  • 现在打开项目时会提示格式已升级,以支持使用 MSBuild 进行生成和部署。Projects now prompt on open to upgraded format to support using MSBuild to build and deploy.

已知问题Known Issues

Analysis Services (AS)Analysis Services (AS)

  • 具有透视的 1400 兼容级别的直接查询模型在查询和发现元数据时失败。Models of 1400 compatibility level in Direct Query mode that have perspectives fail on querying or discovering metadata.

Reporting Services (RS)Reporting Services (RS)

  • 新的报表项目格式不会保留源代码管理绑定,并会引发与以下消息类似的错误:New Report Project format does not retain source control binding, and raises an error similar to the message:

    项目文件 C:\path 未绑定到源代码管理,但该解决方案包含其中的源代码管理绑定信息。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.

  • 将项目升级到新的 MSBuild 格式后,保存可能会失败,消息类似于以下内容:After upgrading your project to the new MSBuild format, save may fail with a message similar to the following:

    “参数 "unevaluatedValue" 不得为 null。”"Parameter "unevaluatedValue" cannot be null."

    若要解决此问题,请更新“项目配置”并填写“平台”属性。To work around this issue, please update your Project Configurations and populate the Platform property.

Bug 修复Bug Fixes

Analysis Services (AS)Analysis Services (AS)

  • 大幅提升了加载表格模型关系图视图时的性能。Vastly improved performance when loading tabular model diagram view.
  • 修复了大量问题,改进了 1400 兼容级别模型中 PowerQuery 的集成和体验。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.
    • 修复了文件源的 UI 显示错误的问题。Fixed an issue Wrong UI displayed for File sources.
  • 修复了在“加入日期”关系处于非活动状态的情况下,导致删除了 "JoinOnDate" 属性的问题。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.
  • 修复了导致对现有数据源查询的编辑不能在 1400 兼容级别下更新表格的模型定义的问题。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.
  • 在 1400 表格模式中采用重复名称导入新的表格时,用户现在会收到通知,指示名称存在冲突,需要调整为唯一的名称。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 集成现支持用于其他数据源(OData.Feed、Odbc.DataSource、Access.Database、SapBusinessWarehouse.Cubes)的选项。PowerQuery integration now supports Options for Additional Data Sources (OData.Feed, Odbc.DataSource, Access.Database, SapBusinessWarehouse.Cubes).
  • 数据源的 PowerQuery 选项字符串现将根据客户端区域设置正确显示本地化文本。PowerQuery Options strings for Data Sources will now correctly show localized text based on client locale.
  • 关系图视图现在可以显示 1400 兼容级别模型中从 M 查询编辑器新建的列。Diagram view now shows newly created columns from M Query Editor in 1400-compat level models.
  • Power Query 编辑器现提供不导入数据的选项。Power Query Editor now gives the option to not import data.
  • 修复了安装数据胶卷过程中的问题,该数据胶卷用于在 VS2017 的多维模型中从 Oracle 导入表格。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.
  • 修复了在多维项目中尝试在角色设计器“单元格数据”选项卡设计器中调用测试多维数据集安全性时,VS2017 中可能发生的故障。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:对于表格数据源,属性是不可编辑的。SSDT: Properties are uneditable for tabular data sources.
  • 修复了可能导致 MSBuild 和 DevEnv 版本在某些情况下无法使用解决方案文件正常工作的问题。Fixed an issue that may have caused MSBuild and DevEnv builds to not work correctly in some cases with solution files.
  • 大幅提升了在表格模型包含更大的元数据的情况下,提交模型更改(针对度量值、计算列的 DAX 编辑)时的性能Vastly improved performance when committing model changes (DAX edits for measures, calculated columns) when tabular model contains larger metadata
  • 修复了在 1400 兼容级别模型中使用 PowerQuery 导入数据的过程中出现的大量问题Fixed a number of issues with importing data using PowerQuery in 1400-compat level models
    • 单击“导入”后需要很长时间才能完成导入,而 UI 不会显示任何状态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
    • 在查询编辑器视图中使用 35 个查询的列表时,查询编辑器的性能低下(PBI 桌面中也会出现该问题)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
    • 使用 PQ 导入表格后,模型设计器处于禁用状态,并且未显示任何数据Model designer appeared disabled and showed no data after import of table using PQ
    • 在 PQ UI 中取消选中“创建新表”,但仍会导致创建新表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
    • 使用 M 表达式打开分区管理器这一操作非常缓慢Opening partition manager with M-expression was very slow
    • 在 PQ 编辑器中选择表格属性,这一操作未显示属性Selecting Properties on table in PQ editor didn't show the properties
  • 提高了在 Power Query UI 集成中捕获顶级异常并在“输出”窗口中显示的可靠性Improved robustness in Power Query UI integration to catch top-level exceptions and show in Output window
  • 修复了结构数据源上的 ChangeSource 在上下文表达式中不会持续更改的问题Fixed an issue with ChangeSource on structure datasource not persisting changes when context expression
  • 修复了 M 表达式错误可能导致无法更新模型,而不显示错误消息的问题Fixed an issue where M expression errors may cause failures to update the model without error message shown
  • 修复了关闭 SSDT 时显示“The build must be stopped before the solution can be closed”错误的问题Fixed an issue closing SSDT with error "The build must be stopped before the solution can be closed"
  • 修复了在 1400 兼容级别模型中设置了错误的模拟模式时,VS 可能出现挂起状态的问题Fixed an issue where VS may appear to hang when setting wrong impersonation mode in 1400 compat-level model
  • 目前,详细信息行属性不为空时,只会序列化为 JSON(更改了默认设置)Detail rows property will now only be serialized to JSON when it is not empty (changed from default)
  • Oracle OLEDB 驱动程序现可用于表格直接查询模式下的列表中Oracle OLEDB driver now available in the list for tabular Direct Query mode
  • 在 1400 兼容表格模型中添加 M 表达式,这一操作现在会在表格模型资源管理器 (TME) 中显示\刷新Adding M-Expressions in 1400-compat tabular models now appear\refresh in the Tabular Model Explorer (TME)
  • 修复了尝试在预先的 1400 兼容级别模型中使用“其他”数据源进行导入时,会导致 MSOLAP 提供程序不会出现在 VS2017 中的问题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
  • 修复了通过 TME 添加转换可能会导致出现问题的问题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)Reporting Services (RS)

  • 修复了在 VS 2017 中编译和生成 RDLC 的过程中出现的问题Fixed an issue with compile and build of RDLC in VS 2017

15.3.0(预览版),SSDT for VS 201715.3.0 (preview),  SSDT for VS 2017

生成号:14.0.16121.0Build number:   14.0.16121.0
SSDT for Visual Studio 2017。SSDT for Visual Studio 2017.

新增功能What's New?

此预览版是 SSDT for Visual Studio 2017 的第一个版本。This preview is the first version of SSDT for Visual Studio 2017. 此版本为 Visual Studio 2017 15.3 及以上版本中的 SQL Server 数据库、Analysis Services、Reporting Services 和 Integration Services 项目引入了独立的 Web 安装体验。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 尚未本地化。SSIS is not localized.
  • 当 ExecuteOutofProcess 设置为 True 时,SSIS 执行包任务不支持调试。SSIS Execute Package Task doesn't support debugging when ExecuteOutofProcess is set to True. 此问题仅适用于调试。This issue only applies to debugging. 通过 DTExec.exe 或 SSIS 目录进行保存、部署和执行将不受影响。Save, deploy, and execution via DTExec.exe or SSIS catalog is not impacted.
  • 不可将包含第三方扩展的 SSIS 包切换为面向其他服务器版本。SSIS Packages containing 3rd party extensions cannot be switched to target other server versions.

17.2,SSDT for VS 201517.2,  SSDT for VS 2015

生成号:14.0.61707.300Build number:   14.0.61707.300
SSDT for Visual Studio 2015。SSDT for Visual Studio 2015.

新增功能What's New?

AS 项目:AS projects:

  • 现可在“角色”对话框中配置“对象级安全性”,便于在 1400 兼容级别表格模型中实现高级安全性。Object Level Security can now be configured in the Roles dialog for advanced security in 1400 compatibility level tabular models.
  • 用于在适用于 VS2017 的 SSDT AS 项目中的 AS Azure 模型中无电子邮件地址用户的新的 AAD 角色成员选择。New AAD role member selection for users without email addresses in AS Azure models in SSDT AS projects for VS2017.
  • SSDT AS 表格项目中新的 AS Azure“始终提示”项目属性,用于自定义 ADAL 凭据缓存的行为。New AS Azure "Always Prompt" project property in SSDT AS tabular projects to customize behavior of ADAL credential caching.

Bug 修复Bug Fixes

常规General

  • 更新了适用于 SQL Server 2017 的品牌引用。Updated branding references for SQL Server 2017.

AS 项目AS projects

  • 为增强提交 DAX 测量更改和其他模型编辑时的体验进行了显著的性能修复。Significant performance fixes made to improve experience when committing DAX measure changes and other model edits.
  • 修复了使用 1400-兼容级别表格模型的 Analysis Services 项目中的 PowerQuery 集成的大量相关问题。Fixed a number of issues with Power Query integration in Analysis Services projects using 1400-compatability level tabular models.
  • 修复了在 VS2017 多维度项目中“设计聚合”设计器可能无法加载的问题。Fixed an issue in Multi-Dimensional projects in VS2017 only where Design Aggregation designer may fail to load.
  • 修复了在 Analysis Services 多维度 DSV 图中拖动项可能导致 VS 2017 崩溃的问题。Fixed an issue when dragging an item in the Analysis Services multi-dimensional DSV diagram that could crash VS 2017.
  • 修复了 AS 项目中“部署”对话框没有始终处于 Visual Studio 前台的问题。Fixed an issue in AS projects where the Deploy Dialog was not always in the foreground on top of Visual Studio.
  • 删除了从作为数据源的数据市场导入 Analysis Services,因为该服务已停用。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.
  • 从 AS 表格项目中的集成工作区切换到显式工作区服务器时,现在将清除旧的数据库文件。When switching from integrated workspace in AS tabular projects to explicit workspace server, the old database files are now be cleaned up.
  • 修复了 AS 表格 1400 模型项目中的一个问题,该问题会导致“行级别安全性”复选框 UI 状态最初显示为未选中,而不管实际的基础对象状态如何。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.
  • 修复了当使用 Power Query 和已引发的未经处理的异常将文本文件或 Excel 文件导入 1400 兼容模式表格模型时可能会发生的崩溃。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.
  • 修复了 AS 表格模型设计器中 DAX 公式编辑控件中的滚动条缩略图可能出现的问题。Fixed an issue that could occur with the scrollbar thumb in the DAX formula editing control in AS tabular model designer.
  • 修复了当包含用户名/密码身份验证时阻止修改 PowerQuery 糅合数据源的问题。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.
  • 修复了当多个 AS 表格模型项目加载和关闭次要模型设计器而未与设计器中的任何内容交互时,可能会导致 VS 崩溃的问题。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.
  • 修复了在某些情况下对 KPI 格式的编辑没有持续存在的问题。Fixed an issue where edits made to KPI formatting were not getting persisted in some cases.
  • 修复了 PowerQuery UI 在不论公式栏是否显示的情况下都显示错误的菜单已检查状态的问题。Fixed an issue with PowerQuery UI that showed the wrong menu checked state for whether the formula bar was shown.
  • 修复了具有 PowerQuery 数据源的 AS 表格 1400 兼容级别项目当从表格模型资源管理器中选择“更改数据源”菜单时,可能会导致 VS 崩溃的问题。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.
  • 修复了导致加载 1400 表格模型可能会显示错误“未能加载文件或程序集‘Microsoft.ProBI.MashupLibrary’”的间歇性问题。Fixed an intermittent issue where loading a 1400 tabular model may show the error 'Could not load file or assembly 'Microsoft.ProBI.MashupLibrary'.

RS 项目RS projects

  • RS“标尺”和“参数”框设置选择状态的用户首选项在会话中会被正确记住。User preferences for RS Ruler and Parameter box settings selection state is remembered correctly across sessions.

IS 项目IS projects

  • 修复了 ADO/ADO.NET ForEachLoop 容器未正确显示的问题Fixed an issue where ADO/ADO.NET ForEachLoop Container didn't show correctly
  • 修复了某些任务/组件/向导未本地化的问题Fixed an issue where some tasks/components/wizards are not localized
  • 将最新 TargetServerVersion 从“SQL Server vNext”更改为“SQL Server 2017”Changed latest TargetServerVersion from "SQL Server vNext" to "SQL Server 2017"

17.10,SSDT for VS 201517.10,  SSDT for VS 2015

生成号:14.0.61705.170Build number:   14.0.61705.170
SSDT for Visual Studio 2015。SSDT for Visual Studio 2015.

新增功能What's New?

AS 项目:AS projects:

  • 用户可以对 1400 模型上用户界面中的列设置编码提示Users can set encoding hints on columns in the UI on 1400 models
  • 现在可在脱机模式下使用非模型相关 IntelliSenseNon-model-related IntelliSense is now available in offline mode
  • 表格模型资源管理器现在包含一个节点,用于表示可跨整个模型(1400 兼容级别表格模型)使用的命名 M 表达式Tabular Model Explorer now contains a node to represent named M expressions available across the model (1400 compatibility level tabular models)
  • Azure Active Directory 人员选取器与 Microsoft Azure 门户的标识和访问管理相似,现可在设置表格模型中的角色成员时使用Azure Active Directory People Picker, similar to Microsoft Azure portal's IAM, now available when setting up Role Members in Tabular Models

数据库项目:Database projects:

  • 更新至 DacFx 17.1Updated to DacFx 17.1

Bug 修复Bug Fixes

  • 修复了 VS2017 Visual Studio 选项中商业智能设计器组名称显示不正确的问题Fixed an issue where the Business Intelligence Designers group name was displayed incorrectly in Visual Studio Options in VS2017
  • 修复了为具有报表项目和 AS 项目的解决方案生成代码图时可能出现崩溃的问题Fixed an issue where a crash could occur generating a Code Map for a solution with a Report Project or AS Project
  • 修复了 Analysis Services 1400 兼容级别表格模型的 PowerQuery 集成的大量相关问题Fixed a number of issues with PowerQuery integration for Analysis Services 1400 compatibility level tabular models
  • 修复了新 DAX 编辑器工具窗口中的问题:定义度量值时赋值运算符不能位于单独一行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
  • 更新了 Analysis Services 集成工作区引擎和表格对象模型,表格对象模型修复了导致包含转换的 1200 表格项目无法部署到 SQL Server 2016 Analysis Services 服务器的回归问题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
  • 修复了导致创建/删除新 1400 表格数据源速度过慢的性能问题Fixed a performance issue that made creation\deletion of new 1400 tabular data sources very slow
  • 修复了在不同 DSV 之间快速切换视图时多维模型中的 DSV 图示可能停止呈现的问题Fixed an issue where the DSV diagram in multi-dimensional models could stop rendering if changing view quickly between different DSVs

DacFx 17.1DacFx 17.1

  • 修复了加密某列时内存优化表具有其他标识列的问题Fixed an issue when encrypting a column with memory-optimized tables with other identity columns
  • 提供用于创建数据库的 CATALOG_COLLATION 选项的 SQLDOM 支持SQLDOM support for CATALOG_COLLATION option for CREATE DATABASE

DacFx 17.0.1DacFx 17.0.1

  • 修复了数据库具有由 HSM 使用 EKM 提供程序进行保护的非对称密钥的相关问题(Connect 项目Fix for issue with databases with an asymmetric key by an HSM with an EKM provider Connect item

17.0,SSDT for VS 201517.0,  SSDT for VS 2015

生成号:14.0.61704.140Build number:   14.0.61704.140
SSDT for Visual Studio 2015。SSDT for Visual Studio 2015.
最高支持 SQL Server 2017。Supports up to SQL Server 2017.

新增功能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.
  • 向 SqlPackage 添加了新的命令行选项:ModelFilePath。Added a new command line option to SqlPackage: ModelFilePath. 这为高级用户提供了一个选项,可用于指定外部 model.xml 文件来执行导入、发布和脚本编写操作This provides an option for advanced users to specify an external model.xml file for import, publishing, and scripting operations
  • 扩展了 DacFx API,用于支持 Azure AD 通用身份验证和多重身份验证 (MFA)The DacFx API was extended to support Azure AD Universal Authentication and Multi-factor authentication (MFA)

IS 项目:IS projects:

  • SSIS OData 源和 OData 连接管理器现支持连接到 Microsoft Dynamics AX Online 和 Microsoft Dynamics CRM Online 的 OData 源。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 项目现在支持“SQL Server 2017”的目标服务器版本SSIS project now supports target server version of "SQL Server 2017"
  • 提供针对 SQL Server 2017 的 CDC 控制任务、CDC 拆分器和 CDC 源支持。Support for CDC Control Task, CDC Splitter and CDC Source when targeting SQL Server 2017.

AS 项目:AS projects:

  • Analysis Services PowerQuery 集成(1400 兼容级别表格模型):Analysis Services PowerQuery Integration (1400 compatibility level tabular models):
    • 如果用户已安装第三方驱动程序,则 DirectQuery 适用于 SQL Oracle 和 TeradataDirectQuery is available for SQL Oracle, And Teradata if user has installed 3rd Party drivers
    • 在 PowerQuery 中按示例添加列Add columns by example in PowerQuery
    • 1400 模型中的数据访问选项(M 引擎使用的模型级别属性)Data access options in 1400 models (model-level properties used by M engine)
      • 启用快速合并(默认为 false - 设置为 true 时,糅合引擎会在合并数据时忽略数据源隐私级别)Enable fast combine (default is false - when set to true, the mashup engine ignores data source privacy levels when combining data)
      • 启用旧版重定向(默认为 false - 设置为 true 时,糅合引擎会跟随可能不安全的 HTTP 重定向。Enable Legacy Redirects (default is false - when set to true, the mashup engine follows HTTP redirects that are potentially insecure.  例如,从 HTTPS 到 HTTP URI 的重定向)  For example, a redirect from an HTTPS to an HTTP URI)  
      • 返回错误值 Null(默认为 false - 设置为 true 时,单元格级别错误会返回 null。Return Error Values as Null (default is false - when set to true, cell level errors are returned as null. 如果设置为 false,单元格包含错误时会引发异常)When false, an exception is raised is a cell contains an error)  
    • 使用 PowerQuery 的其他数据源(文件数据源)Additional data sources (file data sources) using PowerQuery
      • “导出”Excel 
      • Text/CSVText/CSV 
      • XmlXml 
      • JsonJson 
      • 文件夹Folder 
      • Access 数据库Access Database 
      • Azure Blob 存储Azure Blob Storage 
    • 本地化的 PowerQuery 用户界面Localized PowerQuery user interface
  • DAX 编辑器工具窗口DAX Editor Tool Window
    • 改进了针对度量值、计算列和详细行表达式的 DAX 编辑体验,可通过 SSDT 中的“视图”和其他 Windows 菜单使用Improved DAX editing experience for measures, calculated columns, and detail-rows expressions, available via the View, Other Windows menu in SSDT
    • 改进了 DAX 分析程序\IntellisenseImprovements to DAX parser\Intellisense

RS 项目:RS projects:

  • 现在,可使用可嵌入的 RVC 控件以支持 SSRS 2016Embeddable RVC Control is now available supporting SSRS 2016

Bug 修复Bug fixes

AS 项目:AS projects:

  • 解决了 BI 项目的模板优先级问题,使其不在 VS 新项目类别的最上面显示Fixed the template priority for BI Projects so they don't show up at the top of the New Projects categories in VS
  • 修复了在打开 SSIS、SSAS 或 SSRS 解决方案时极少数情况下发生的 VS 故障Fixed a VS crash that may occur in rare circumstances when SSIS, SSAS or SSRS solution opened
  • 表格:针对 DAX 分析和公式栏的多种增强和性能修复。Tabular: A variety of enhancements and performance fixes for DAX parsing and the formula bar.
  • 表格:如果没有打开 SSAS 表格项目,则不显示表格模型资源管理器。Tabular: Tabular Model Explorer will no longer be visible if no SSAS Tabular projects are open.
  • 多维:解决了高 DPI 计算机上处理对话框不可用的问题。Multi-dimensional: Fixed an issue where the processing dialog was unusable on High-DPI machines.
  • 表格:解决了在已打开 SSMS 的情况下,打开任何 BI 项目将导致 SSDT 故障的问题。Tabular: Fixed an issue where SSDT faults when opening any BI project when SSMS is already open. 连接项Connect Item
  • 表格:解决了在 1103 模式下层次结构未正确保存到 bim 文件的问题。连接项Tabular: Fixed an issue where hierarchies were not being properly saved to the bim file in an 1103 model.Connect Item
  • 表格:解决了尽管不支持,但仍能在 32 位计算机上允许集成工作区模式的问题。Tabular: Fixed an issue where Integrated Workspace mode was allowed on 32-bit machines even though it is not supported.
  • 表格:解决了在准选择模式下单击任何内容(例如键入 DAX 表达式,但单击一个度量值)可能导致崩溃的问题。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.
  • 表格:解决了部署向导将模型的 .Name 属性重置为“模型”的问题。Tabular: Fixed an issue where Deployment Wizard would reset the model's .Name property back to "Model". 连接项Connect Item
  • 表格:修复了在 TME 中选择层次结构时,即使未选择关系图视图也应显示属性的问题。Tabular: Fixed an issue where selecting a hierarchy in TME should display properties even if Diagram View is not selected.
  • 表格:解决了从某些应用程序中粘贴时,粘贴到 DAX 公式栏的操作将粘贴图像或其他内容(而非文本)的问题。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.
  • 表格:解决了由于存在具有特定定义的度量值,无法打开 1103 中某些旧模型的问题。Tabular: Fixed an issue where some old models in the 1103 couldn't be opened due to presence of measures with a specific definition.
  • 表格:解决了无法删除 XEvent 会话的问题。Tabular: Fixed an issue where XEvent Sessions could not be deleted.
  • 解决了无法使用 devenv.com 生成 AS“smproj”文件的问题Fixed an issue with attempting to build AS "smproj" files with devenv.com would fail
  • 解决了在 AS 表格模型工作表标签标题中使用朝鲜语输入法时,文本更改过于频繁的问题Fixed an issue that was finalizing text changes too frequently when using the Korean IME in AS tabular model sheet tab titles
  • 解决了 DAX Related() 函数的 IntelliSense 无法正常显示其他表中列的问题Fixed an issue where the intellisense for DAX Related() function was not working correctly to show columns from other tables
  • 通过对 AS 数据库的列表进行排序,改进了从数据库对话框执行的 AS 表格项目导入操作Improved AS Tabular project import from database dialog by sorting the list of AS databases
  • 解决了在 AS 表格模型中创建计算表时,表达式中没有将表列为建议对象的问题Fixed an issue when creating calculated tables in AS tabular model where Tables weren't listed as suggested objects in the expression
  • 解决了在查看代码后尝试使用集成工作区服务器打开预览 1400 AS 模型时遇到的问题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
  • 解决了只有在重新选择现有 AS 连接的“高级属性”对话框后,才能看到完整列表的问题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
  • 修复了 1400 兼容级别 AS 表格模型中 PowerQuery 集成的大量相关问题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
  • 修复了从 SQL 更改为 AS 时报表向导可能导致数据源设置错误的问题Fixed an issue with the Report Wizard that could lead to incorrect data source settings when changing from SQL to AS
  • 修复了导致 Analysis Services(表格)项目在命令行 (devenv.com\exe) 中生成失败的问题Fixed an issue causing Analysis Services (Tabular) project build failure from command line (devenv.com\exe)
  • 修复了 DAX 度量值分析器的问题:在 := 前以字母开头时,其显示突出显示的内容和正确的文本颜色Fixed an issue with the DAX measure parser to show highlighted and correct text color when starting with letters before :=
  • 修复了此问题:如果路径过长,尝试在集成工作区模式下对表格项目选择“显示所有文件”时,将触发 ObjectRefExceptionFixed an issue triggering an ObjectRefException if paths got too long attempting to Show All Files for Tabular project in integrated workspace mode
  • 修复了 Compact 4.0 客户端数据提供程序的数据源设计器不可用的问题Fixed an issue with the Data Source Designer for Compact 4.0 Client Data Provider where it appeared unavailable
  • 修复了在 VS2017 中尝试浏览 AS 挖掘模型时导致出错的问题Fixed an issue that caused an error trying to browse AS mining model in VS2017
  • 修复了 VS2017 中 AS 多维模型的相关问题:更改视图后,DSV 图示阻止呈现并引发异常Fixed an issue in AS multi-dimensional model in VS2017 where DSV diagram stops rendering after changing views and then hits an exception
  • 修复了在 VS2017 中预览报表时 AS 连接失败的问题Fixed an issue previewing reports with an AS connection failed in VS2017

RS 项目:RS projects:

  • 解决了在 SSDT 中设计报表时多数更改会导致参数、数据源和数据集的树状视图发生折叠的问题Fixed an issue when designing reports in SSDT the tree view of parameters, data sources and datasets would collapse when most changes made
  • 解决了“保存”应该保存 RDL 的版本而非最新版本的问题。Fixed an issue where Save should save the version of RDL, not the latest version.
  • 解决了当备份已关闭时,SSDT RS 备份文件的问题以及一些其他问题。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 项目:IS projects:

  • 解决了 run64bitruntime 设置不粘滞的问题。Fixed an issue that run64bitruntime setting doesn't stick.
  • 解决了 DataViewer 不保存所显示的列的问题。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
  • 解决了从 SQL 服务器导入项目时 SSDT 崩溃的问题。Fixed an issue that SSDT crashes when importing project from sql server.
  • 修复了 Hadoop 文件系统任务 TimeoutInMinutes 的问题:打开已保存的 SSIS 包后和在运行时,其默认值为 10。Fixed an issue with Hadoop File System Task TimeoutInMinutes default to 10 after opening saved SSIS package and at runtime.

数据库项目:Database projects:

  • SSDT DACPAC 重新部署并添加 IgnoreColumnOrder 设置 连接项SSDT DACPAC deploy add setting back in for IgnoreColumnOrder Connect item
  • SSDT 在使用 STRING_SPLIT 的情况下会编译失败 连接项SSDT failing to compile if STRING_SPLIT is used Connect item
  • 解决了 DeploymentContributors 有权访问公共模型,但支持架构尚未初始化的问题 Github 问题Fix issue where DeploymentContributors have access to the public model but the backing schema has not been initialized Github issue
  • FILEGROUP 位置的 DacFx 临时修补程序DacFx temporal fix for FILEGROUP placement
  • 修复了外部同义词的“未解析的引用”错误。Fix for "Unresolved Reference" error for external synonyms.
  • Always Encrypted:联机加密无法禁用对取消项进行更改跟踪,并且如果在开始加密前尚未清除更改跟踪,联机加密也无法正常运行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

16.5,SSDT for VS 201516.5,  SSDT for VS 2015

发布时间:2016 年 10 月 20 日Released:   October 20, 2016
生成号:14.0.61021.0Build number:   14.0.61021.0
SSDT for Visual Studio 2015。SSDT for Visual Studio 2015.
最高支持 SQL Server 2016。Supports up to SQL Server 2016.

新增功能What's New?

连接改进Connection Improvements

  • “浏览”选项卡中的新搜索框可帮助你筛选本地服务器、网络服务器和 Azure SQL 数据库。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 和 DacFx API 改进SqlPackage and DacFx API Improvements

现在,使用 SqlPackage.exe 和 DacFx API 可以通过一项操作来生成部署报告和部署脚本,以及发布到数据库。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. 另一项优势是,在 Azure 方案中,将会针对 master 数据库和部署目标数据库创建单独的脚本。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.

针对 SqlPackage 的发布和脚本操作,已添加两个新参数。For SqlPackage's Publish and Script actions, two new arguments have been added.

  • DeployScriptPath(短名称:dsp)。DeployScriptPath (shortname: dsp). 这是要将部署脚本写入到的可选路径。This is an optional path to write the deployment script to. 对于 Azure 部署,如果使用 TSQL 命令创建或修改了数据库,则会将主脚本写入相同的路径,但使用“Filename_Master.sql”作为输出文件名。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(短名称:drp)。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"

DacFx 中添加了两个新 API:DacServices.Publish() 和 DacServices.Script()。In DacFx, two new APIs have been added: DacServices.Publish() and DacServices.Script(). 这些 API 还支持通过单个操作执行发布 + 脚本 + 报告操作。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 ServicesAnalysis Services & Reporting Services

在处理较大的 DAX 表达式时,SSAS 表格设计器 DAX 分析器的性能已得到改进。SSAS tabular designer DAX parser has improved performance when working with large DAX expressions. 有关详细信息,请阅读 Analysis Services 博客文章For more information, please read the Analysis Services blog post.

本月修复/改进的功能Fixed / Improved this month

Database ToolsDatabase Tools

  • 连接 bug 3055711 - 无法从使用显式架构的 CROSS APPLY OPENJSON 中选择列Connect bug 3055711 - Columns cannot be selected from CROSS APPLY OPENJSON with explicit schema
  • 已修复 - 自动生成的历史记录表索引问题:重新部署时 DacFx 会删除索引Fixed - issue with Auto-generated History table indexes, where DacFx dropped index on redeployment
  • 已修复 - DacFx 批处理分析器无法分析转义的括号“]”字符,导致发布失败的问题Fixed - issue with DacFx batch parser not parsing escaped bracket ']' characters, which caused publish to fail
  • 已改进 - 现在,SqlPackage 将在帮助输出中包含每个操作的说明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
  • 已修复 - 对于“历史记录”选项卡中显示的、IntegratedAuthentication = true 的连接,连接属性中的“身份验证”字段保留空白。Fixed - For connections show in the History tab with IntegratedAuthentication=true, the Authentication field in connection properties was left blank. 现在会按预期显示“Windows 身份验证”This now shows "Windows Authentication" as expected
  • 已修复 - 不会保留对“工具”->“选项”->“文本编辑器”下的“SQL Server Tools Intellisense”设置所做的更改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 ServicesAnalysis Services & Reporting Services

  • 修复了 SSDT AS 表格设计器中的一个问题:在某些情况下,单击数据网格中的滚动条 Thumb 控件会导致崩溃Fixed an issue in SSDT AS tabular designer where clicking the scrollbar thumb in data grid crashed in certain situations
  • 修复了 SSDT AS 表格设计器中未提供以当前用户模拟连接的选项问题Fixed an issue where option to impersonate connection as current user in SSDT AS tabular wasn't available
  • 修复了 SSDT AS 表格设计器中的一个问题:过度展开公式栏可能导致项目无法重新打开Fixed an issue in SSDT AS tabular designer where expanding the formula bar too far could make the project unable to re-open
  • 修复了在选择表选项卡后,按键时发生 SSDT AS 表格设计器崩溃的问题Fixed a crash in SSDT AS tabular designer that would occur on key down if table tab was selected
  • 修复了 SSDT AS 项目中的一个问题:选择“在 Excel 中分析”不会连接到下层 AS 服务器版本Fixed an issue in SSDT AS projects where Analyze in Excel would not connect to down-level AS server versions

集成服务Integration Service

  • 修复了连接 bug  1608896:移动多个集成服务包任务Fixed Connect bug 1608896: Move Multiple Integration Service Package Tasks

16.4,SSDT for VS 201516.4, SSDT for VS 2015

发布时间:2016 年 9 月 20 日Released:   September 20, 2016
生成号:14.0.60918Build number:   14.0.60918
适用于 SQL Server 2016。For SQL Server 2016.

新增功能What's New?

现在,SqlPackage.exe 和数据层应用程序框架 (DacFx) API 支持架构比较。Schema Compare is now supported in SqlPackage.exe and the Data-Tier Application Framework (DacFx) API. 有关详细信息,请参阅  Schema Compare in SqlPackage and the Data-Tier Application Framework(SqlPackage 和数据层应用程序框架中的架构比较)。For details, see Schema Compare in SqlPackage and the Data-Tier Application Framework.

Analysis Services - 适用于 SSDT Tabular 的集成工作区模式 (SSAS)Analysis Services - Integrated Workspace Mode for SSDT Tabular (SSAS)

SSDT Tabular 现在包含内部 SSAS 实例,如果启用集成工作区模式,SSDT Tabular 将在后台自动启动该实例,使你能够在模型设计器中添加和查看表、列与数据,而无需提供外部工作区服务器实例。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. 集成工作区模式不会更改 SSDT 表格与工作区服务器和数据库配合工作的方式。Integrated workspace mode does not change how SSDT Tabular works with a workspace server and database. 更改的是 SSDT 表格托管工作区数据库的位置。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. 对于当前使用显式工作区服务器的现有表格项目,可以通过在“属性”窗口(在解决方案资源管理器中选择 Model.bim 文件时会显示该窗口)中,将“集成工作区模式”参数设置为 True 切换到集成工作区模式。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. 有关详细信息,请参阅 Analysis Services 博客文章For details, see the Analysis Services blog post.

更新和修复 数据库工具:Updates and fixes Database tools:

Analysis Services 和 Reporting ServicesAnalysis Services & Reporting Services

  • 修复了 SSDT 中的一个问题:编辑 DirectQuery 的 DAX 计算列时错误提示弹出窗口会妨碍操作。Fixed an issue in SSDT where error tip pop-ups were in the way when editing DAX for DirectQuery calculated columns.
  • 修复了 SSDT AS 表格网格中的一个问题:当 Windows 缩放系数设置为高 DPI 200% 以上时,KPI 图标不会显示在度量网格中。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%+.
  • 修复了 SSDT AS 中的一个问题:粘贴大型表数据可能导致表格项目无响应。Fixed an issue in SSDT AS where pasting large table data could make the tabular project unresponsive.
  • 修复了 SSDT AS 表格模型编辑器中的一个问题。现在,在重命名连接的友好名称时,会将模型标记为需要保存更改。Fixed an issue in SSDT AS tabular model editor to mark the model as needing to save changes when renaming connection friendly name.
  • 修复了 SSDT AS 表格项目中的一个问题:无法调整管理关系对话框中的列宽。Fixed an issue in the SSDT AS tabular projects where width of columns in the manage relationships dialog could not be resized.
  • 修复了 SSDT AS 表格 1200 级模型中的一个问题:使用“德语”等区域设置时,从 Excel 粘贴数据无法正确将逗号视为小数分隔符。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.
  • 修复了 SSDT AS 项目中的一个问题:某些 KPI 图标集可能会产生错误“无法检索此视觉对象的数据”。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".
  • 修复了 SSDT AS 项目属性对话框中的一个问题。现在,在以高 DPI 缩放比例调整大小时,可以正确定位。Fixed an issue with SSDT AS project properties dialog to anchored correctly when resized at High-DPI scaling.
  • 修复了 SSDT AS 项目中一个可能会导致升级包含粘贴表的某些模型时出错的问题。Fixed an issue in SSDT AS projects that may have caused an error upgrading certain models with Pasted tables.
  • 修复了 SSDT AS 中的一个问题:从 Excel 粘贴所有工作表行时速度非常缓慢,并且会创建许多不需要的列。Fixed an issue in SSDT AS where pasting full sheet rows from Excel was very slow and created many unwanted columns.
  • 修复了 SSDT AS 中的一个问题:大型静态 DataTable 表达式的分析和突出显示速度非常缓慢,似乎已挂起。Fixed an issue in SSDT AS where large static DataTable expressions parsing and highlight was really slow or appeared to hang.
  • 修复了 SSDT AS 中的一个问题,现在会将度量值和 KPI 值添加到在编辑器中选择的当前透视图。Fixed an issue in SSDT AS to add measures and KPI values to the current perspective selected in the editor.
  • 修复了 SSDT 中的一个问题:从 SQL Azure 导入 AS 项目的数据不支持除“dbo”以外的架构类型。Fixed an issue in SSDT where data import into AS project from SQL Azure didn't support schema types other than "dbo".

16.3,SSDT for VS 201516.3,  SSDT for VS 2015

发布时间:2016 年 8 月 15 日Released:   August 15, 2016
生成号:14.0.60812.0Build number:   14.0.60812.0
适用于 SQL Server 2016。For SQL Server 2016.

新增功能What's New?

  • 发行版本控制和编号: 现在,发行版按编号顺序而不是按月份进行标记。Release Versioning & Numbering: Releases are now tagged numerically rather than by month. 这符合新的 SSMS 策略;当某个月份推出多个版本或修补程序时,这种版本控制方式可以简化我们的工作。This aligns with the new SSMS policy and simplifies cases where we have multiple releases or hotfixes in a month. 此发行版为 16.3,表示自 RTM 发行版推出之后的第三次更新。This release is 16.3 which means the third update after the RTM release. 任何修补程序的版本从 16.3.1 开始递增,下一次更新(计划在下个月推出)的版本为 16.4。Any hotfix will be 16.3.1 and so on, with our next update (planned for next month) being 16.4.
  • Analysis Services - 表格模型资源管理器: 使用表格模型资源管理器可以方便地浏览模型中的各种元数据对象,例如数据源、表、度量值和关系。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. 它是以单独的工具窗口实现的,在 Visual Studio 中打开“视图”菜单,指向“其他窗口”,然后单击“表格模型资源管理器”即可显示。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. 表格模型资源管理器默认显示在单独选项卡上的“解决方案资源管理器”区域中。表格模型资源管理器在树结构中组织元数据对象,该结构和 1200 表格模型的架构很相似,并提供其他许多新功能。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.
  • 数据库工具 - Always Encrypted:此发行版提供新的 Always Encrypted 密钥管理 对话框,方便你在数据库项目中添加列主密钥或列加密密钥,或者在 SQL Server 对象资源管理器中添加实时数据库。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. 此发行版支持 Windows 证书存储中的证书。This release supports certificates in Windows Certificate Store. 以后的发行版将支持 Azure Key Vault 和 CNG 提供程序。In upcoming releases, Azure Key Vault and CNG Providers will be supported.
    • 创建列主密钥或列加密密钥时,单击“更新数据库”后,更改可能不会立即显示在 SQL Server 对象资源管理器中。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. 若要解决此问题,可在 SQL Server 对象资源管理器中刷新数据库节点。To workaround, refresh the database node in SQL Server Object Explorer.
    • 如果尝试加密某个表中包含 SQL Server 对象资源管理器中数据的列,该操作可能会失败。If you try to encrypt a column in a table with data from SQL Server Object Explorer, you may experience a failure. 此功能目前仅在 SSDT 数据库项目和 SSMS 中受支持。This feature is currently supported only in SSDT database projects and SSMS. 以后的发行版将会实现对 SQL Server 对象资源管理器的支持。Support for SQL Server Object Explorer will be enabled in a later release.

更新和修复Updates and fixes

  • 数据库工具:Database tools:
    • SSDT:SSDT:
    • DACFx:DACFx:
      • 修复了以下问题:由于发生 SqlAzureV12 错误,DACFx 兼容级别未更新。Fixed an issue where DACFx compatibility level is not updated for SqlAzureV12 error.
      • 修复了以下问题:从模型比较中错误地排除 IsAutoGeneratedHistoryTable 属性。Fixed an issue where IsAutoGeneratedHistoryTable property is incorrectly excluded from model comparison.
  • Analysis Services 和 Reporting ServicesAnalysis Services & Reporting Services
    • SSDT:SSDT:
      • 修复了服务器连接断开时无法保存表格模型的问题。Fixed an issue that Tabular model cannot be saved when the server connection is lost.
      • 修复了以下问题:由于 AS 中可能存在无限循环问题,SSDT 无响应。Fixed an issue that SSDT becomes unresponsive due to a possible infinite loop issue in AS.
      • 修复了以下问题:根据 DAX 表达式的提交方式,该表达式会导致不一致的行为。Fixed a DAX expression issue that caused inconsistent behaviors based on how you commit the expression .
      • 修复了创建 KPI 时 VS 崩溃的问题。Fixed a VS crash issue when creating KPIs.
      • 修复了针对 SQL Server 2008 R2、2012 和 2014 生成无效报告的问题。Fixed an issue that generated invalid reports for SQL Server 2008 R2, 2012 and 2014.
      • 修复了导致 .dwpro 项目发生无限循环错误的层次结构顺序问题。Fixed a hierarchy order issue that caused an infinite loop error for .dwpro project.
      • 修复了一个 RS RDL 问题:降级 RDL 要求完全重新生成,使用户感到迷惑。Fixed a RS RDL issue where downgrading RDL required a full rebuild which caused user's confusion.
      • 修复了一个 KPI 问题:“从客户端工具中隐藏”不起作用。Fixed a KPI issue where Hide From Client Tools had no effect.

2016 年 7 月,SSDT for VS 2015July 2016,  SSDT for VS 2015

发布时间:2016 年 6 月 30 日Released:   June 30, 2016
生成号:14.0.60629.0Build number:   14.0.60629.0
适用于 SQL Server 2016。For SQL Server 2016.

新增功能What's New?

  • Always Encrypted 支持: 对于包含 Always Encrypted 列的数据库,此发行版通过我们的核心 API 和命令行工具 (SqlPackage.exe) 添加了对 Always Encrypted 的完全支持。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). 你可以生成并发布完全支持所有 Always Encrypted 功能的数据库项目。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 和安装更改: 从 SQL Server 引擎中隔离 SSDT 的方式发生更改,SSMS 有了更新。SqlPackage.exe and installation changes: Changes to isolate SSDT from SQL Server engine and SSMS updates. 有关详细信息,请参阅 Changes to SSDT and SqlPackage.exe installation and updates(SSDT 和 SqlPackage.exe 安装与更新的更改)。For details, see Changes to SSDT and SqlPackage.exe installation and updates.

更新和修复Updates and fixes

  • 数据库工具:Database tools:

    • 从现在起,SSDT 永远不会在数据库中禁用透明数据加密 (TDE)。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.
    • 增大了初始连接期间的重试计数和 Azure SQL DB 连接的复原能力。Increased the retry count and resiliency for Azure SQL DB connections during initial connection.
    • 如果默认文件组不是 PRIMARY,导入/发布到 Azure V12 将会失败。If the default filegroup is not PRIMARY, Import/Publish 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.
    • 修复了以下问题:创建 Hekaton 表时错误地添加 TEXTIMAGE_ON 选项,这是不允许的。Fixed an issue where the TEXTIMAGE_ON option was incorrectly added for Hekaton table creations where it is not allowed.
    • 修复了以下问题:导出大量数据时,导出需要花费很长时间,原因是数据阶段完成后写入 model.xml 文件导致重写 .bacpac 文件的内容。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.
    • 修复了以下问题:用户未显示在 Azure SQL 数据仓库和 APS 连接的“安全”文件夹中。Fixed an issue where Users were not appearing in the Security folder for Azure SQL DW and APS connections.
  • Analysis Services 和 Reporting Services:Analysis Services & Reporting Services:

    • 修复了 MSOLAP OLEDB 提供程序的一个 SxS 问题:只安装 32 位提供程序,从而影响 64 位 Excel 2016 连接到 SQL Server 2014(在 Office365 中执行 ClickOnce 安装不会出现此问题,只有执行 MSI Excel 安装时才出现)。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).
    • 修复了将包含粘贴表的 AS 模型从 1103 升级到 1200 兼容级别时,可能出现错误“关系使用无效的列 ID”的问题,使该极端情况变得更可靠。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".
    • 修复了一个 SxS 问题:卸载 SSDT 2015(装入共享注册表设置)后,同一台计算机上的 SSDT BI 2013 不再能够导入 AS 模型中的数据。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).
    • 改进了可靠性,解决了当与 AS 引擎的连接断开(例如,SSDT 保持打开一整夜、AS 服务器被回收,或者暂时断开连接的其他情况)时发生的问题/崩溃。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).
    • 修复了在多监视器方案中,对话框在非 VS 的屏幕上打开的问题。Fixed issues with dialogs opening on different screens than VS in multi-monitor scenarios.
    • 已修复/已启用从 AS 模型粘贴表中的 HTML 表(网格数据)粘贴的支持。Fixed/enabled support for pasting from HTML tables (grid data) in AS model pasted tables.
    • 修复了无法将空白粘贴表升级到 1200(只用作用于度量的容器表)的问题。Fixed issue where upgrade failed to upgrade an empty pasted table to 1200 (used only as container table for measures).
    • 修复了有关以下操作的问题:将包含粘贴表的 AS 表格模型升级到 1200 来解决 CalcTables(用于 1200 中的粘贴表)的 AS 引擎问题,以便在升级后针对新的计算表执行完整过程。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.
    • 修复了以下问题:取消创建包含不完整 DAX 表达式的新 AS 1200 模型计算表可能会崩溃。Fixed an issue where canceling creation of new AS 1200 model calculated table with incomplete DAX expression could crash.
    • 修复了当数据库名称与表名称相同时,将 1200 模型从服务器导入 SSDT AS 项目时出现的问题。Fixed an issue importing 1200 model from AS server into SSDT AS project when DB name and a table name were the same.
    • 修复了在 1103 表格模型中编辑 KPI 度量值时出现的问题。Fixed an issue with editing KPI measure in 1103 tabular model.
    • 修复了在网格中为 AS 1200 模型粘贴 KPI 度量值时,对象引用未设置异常命中的问题。Fixed an Object reference not set exception hit while pasting a KPI measure in the grid for an AS 1200 model.
    • 修复了以下问题:无法从 1200 模型的图示视图中删除计算表中的列。Fixed an issue where a column in a calculated table could not be deleted from the diagram view in 1200 models.
    • 修复了在代码视图中查看 model.bim 项目文件属性时,对象引用未设置异常命中的问题。Fixed an Object Reference not set exception when viewing the model.bim project file properties while in code view.
    • 修复了以下问题:在使用逗号作为小数分隔符的国际区域设置中,将数据粘贴到 AS 模型网格以创建粘贴表时,会生成错误的值。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.
    • 修复了在 SSDT 中打开 2008 RS 项目并选择不升级该项目时出现的问题。Fixed an issue opening 2008 RS project in SSDT and choosing to not upgrade it.
    • 修复了为列类型使用默认格式,以便能够从 UI 更改格式类型时,1200 兼容级别模型计算表中存在的问题。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.

2016 年 6 月,SSDT for VS 2015June 2016,  SSDT for VS 2015

发布时间:2016 年 6 月 1 日Released:   June 1, 2016
生成号:14.0.60525.0Build number:   14.0.60525.0
适用于 SQL Server 2016。For SQL Server 2016.

SSDT 正式版 (GA) 现已发布。SSDT General Availability (GA) is now released. 2016 年 6 月 SSDT GA 更新添加了对 SQL Server 2016 RTM 最新更新的支持,并修复了多个 bug。The SSDT GA update for June 2016 adds support for the latest updates of SQL Server 2016 RTM, and various bug fixes. 有关详细信息,请参阅 SQL Server Data Tools GA update for June 2016(SQL Server Data Tools GA 2016 年 6 月更新)。For details, see SQL Server Data Tools GA update for June 2016.

其他资源Additional Resources

下载 SQL Server Data Tools (SSDT)Download SQL Server Data Tools (SSDT)
以前版本的 SQL Server Data Tools(SSDT 和 SSDT-BI)Previous releases of SQL Server Data Tools (SSDT and SSDT-BI)
数据库引擎中的新增功能What's New in Database Engine
Analysis Services 中的新增功能What's New in Analysis Services
Integration Services 中的新增功能What's New in Integration Services