安装 SSDT (SQL Server Data Tools) 时出错

Error when installing SSDT (SQL Server Data Tools)

提问by Edwin

I have a problem during the installation of SQL Server Data Tools for Visual Studio 2017

我在安装 SQL Server Data Tools for Visual Studio 2017 的过程中遇到问题

I get the following error (translated):

我收到以下错误（已翻译）：

The requested meta file operation is not supported (0x800707D3)

Screenshot: See here

截图：看这里

Log file available here: https://www.dropbox.com/s/e34kry9ycj76j7n/SSDT-Setup-ENU_20171219090643.log?dl=0

可在此处获取日志文件：https: //www.dropbox.com/s/e34kry9ycj76j7n/SSDT-Setup-ENU_20171219090643.log?dl=0

Here's the relevant section from the linked log file:

这是链接日志文件中的相关部分：

[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:07:22]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:49]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageActionProgress: Percent completed: 0, Overall progress: 27
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageAction: Install Completed for package SQL Server Integration Services 2012 (id: SSISOneDesigner2012)
[13C4:3020][2017-12-19T10:08:51]i319: Applied rollback package: SSISOneDesigner2012, result: 0x0, restart: None
[4214:2830][2017-12-19T10:08:51]i329: Removed package dependency provider: {DB97C76B-9116-42C5-8814-0041856EB9E6}, package: SSISOneDesigner2012
[4214:2830][2017-12-19T10:08:51]i329: Removed package dependency provider: Microsoft.DataTools.ReportingServices, package: Microsoft.DataTools.ReportingServices
[4214:2830][2017-12-19T10:08:51]i329: Removed package dependency provider: Microsoft.DataTools.AnalysisServices, package: Microsoft.DataTools.AnalysisServices
[13C4:3020][2017-12-19T10:08:51]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 100
[4214:2830][2017-12-19T10:08:51]i372: Session end, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{058aacb1-dd61-42d2-951e-fc2d0b51c456}, resume: None, restart: None, disable resume: No
[4214:2830][2017-12-19T10:08:51]i330: Removed bundle dependency provider: {058aacb1-dd61-42d2-951e-fc2d0b51c456}
[4214:2830][2017-12-19T10:08:51]i352: Removing cached bundle: {058aacb1-dd61-42d2-951e-fc2d0b51c456}, from path: C:\ProgramData\Package Cache\{058aacb1-dd61-42d2-951e-fc2d0b51c456}\
[4214:2830][2017-12-19T10:08:51]i371: Updating session, registration key: SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{058aacb1-dd61-42d2-951e-fc2d0b51c456}, resume: None, restart initiated: No, disable resume: No
[13C4:3020][2017-12-19T10:08:51]e000: MainViewModel.OnBundleAction: Bundle action failed: De aangevraagde metabestandsbewerking wordt niet ondersteund (0x800707D3)
[13C4:3020][2017-12-19T10:08:51]i399: Apply complete, result: 0x800707d3, restart: None, ba requested restart:  No
[13C4:2DC4][2017-12-19T10:09:07]i000: MainViewModel.OpenUrl: Opening url: C:\Users\GEBRUI~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20171219090643.log
[13C4:2DC4][2017-12-19T10:10:35]i000: MainViewModel.OpenUrl: Opening url: 
C:\Users\GEBRUI~1\AppData\Local\Temp\SsdtSetup\SSDT-Setup-ENU_20171219090643.log

I have installed SQL Server Management Studio 17, and then SQL Server 2017 shortly before.

我已经安装了 SQL Server Management Studio 17，不久之前又安装了 SQL Server 2017。

-

——

Can anyone help with this?

有人能帮忙吗？

回答by mhenry1384

I got this attempting to install SSDT to Visual Studio 2019 (the only version of VS I have installed). Fixed by telling SSDT to install the standalone Visual Studio 2017 option, and installed the extension "SQL Server Integration Services Projects" in Visual Studio 2019.

我试图将 SSDT 安装到 Visual Studio 2019（我安装的唯一 VS 版本）。通过告诉 SSDT 安装独立的 Visual Studio 2017 选项进行修复，并在 Visual Studio 2019 中安装了扩展“SQL Server 集成服务项目”。

回答by Tim Bellingham

I was getting the exact same error. I had to repair my instance of Visual Studio Professional 2017 as that is where I was installing the tools. After repairing that instance, had no problems with setting up SSDT. Luckily I had just installed Visual Studio so I didn't lose any configuration.

我得到了完全相同的错误。我必须修复我的 Visual Studio Professional 2017 实例，因为这是我安装工具的地方。修复该实例后，设置 SSDT 没有问题。幸运的是我刚刚安装了 Visual Studio，所以我没有丢失任何配置。

回答by Lyft

What worked for me, was to restart the computer and restart the installation of SSDT.

对我有用的是重新启动计算机并重新启动 SSDT 的安装。

I installed Visual studio within the SSDT setup.

我在 SSDT 设置中安装了 Visual Studio。

回答by sanber

Download and install the following .vsixfiles from Microsoft(i got these link from log):

.vsix从 Microsoft下载并安装以下文件（我从日志中获得了这些链接）：

• Microsoft.DataTools.IntegrationServices: https://go.microsoft.com/fwlink/?LinkId=871369
• Microsoft.DataTools.AnalysisServices: https://go.microsoft.com/fwlink/?linkid=870525
• Microsoft.DataTools.ReportingServices: https://go.microsoft.com/fwlink/?linkid=870526

• Microsoft.DataTools.IntegrationServices：https: //go.microsoft.com/fwlink/?LinkId=871369
• Microsoft.DataTools.AnalysisServices：https: //go.microsoft.com/fwlink/?linkid=870525
• Microsoft.DataTools.ReportingServices：https: //go.microsoft.com/fwlink/?linkid=870526

回答by jajhonrod

In my case SSISOneDesigner2014.msi was giving me an error to download in the log, and the only workaround was executing the offlineSSDT install since I've already had a Visual Studio 2017 instance, executing

在我的情况下，SSISOneDesigner2014.msi 在日志中给我一个下载错误，唯一的解决方法是执行离线SSDT 安装，因为我已经有了一个 Visual Studio 2017 实例，执行

SSDT-Setup-ENU.exe /layout c:\<filepath>

(Where filepathis any location you want to download installer files.)

（其中filepath是您要下载安装程序文件的任何位置。）

Then, manually download SSISOneDesigner2014.msi and copy in c:\<filepath>\payload

然后，手动下载 SSISOneDesigner2014.msi 并复制进去 c:\<filepath>\payload

After that execute the following:

之后执行以下操作：

SSDT-Setup-ENU.exe /install

This correctly installed the rest of the components.

这正确安装了其余的组件。

回答by rvphx

I know this is an old question, but what worked for me was to right click on the SSDT installer (download it to your laptop/PC instead of running it from your browser) and run it as an administrator. I was lucky enough to get it to work without any other steps.

我知道这是一个老问题，但对我有用的是右键单击 SSDT 安装程序（将其下载到您的笔记本电脑/PC，而不是从您的浏览器运行它）并以管理员身份运行它。我很幸运能在没有任何其他步骤的情况下让它工作。