SSIS(SQL Server 集成服务)安装失败 [英] SSIS (SQL Server Integration Services) installation failed

问题描述

安装 Microsoft.DataTools.IntegrationServices.exe在已安装 Visual Studio 2019 的 Windows 10 PC 上，我收到此错误:

installing the Microsoft.DataTools.IntegrationServices.exe on a Windows 10 PC, with Visual Studio 2019 already installed, I got this error:

谁能帮我理解为什么会这样?

Can anyone help me understand why this happens?

非常感谢.

路易斯

这里是日志文件的最后一部分:

Here the last part of the log file:

[5CD0:13EC][2021-05-31T19:42:29]i319:应用的执行包:ISVsix，结果:0x80131500，重启:无[5CD0:13EC][2021-05-31T19:42:29]e000:错误 0x80131500:未能执行EXE包.[0AEC:278C][2021-05-31T19:42:29]i329:已删除包依赖提供者:ISVsix，包:ISVsix[0AEC:278C][2021-05-31T19:42:29]i351:删除缓存包:ISVsix，来自路径:C:\ProgramData\Package缓存\15160B731819F56D87A626F9A2777550340022D7
[0AEC:278C][2021-05-31T19:42:29]i326:删除了依赖项:{ab4889d7-79a3-40dc-9c9e-ccbeca99d453} 包提供商:ISVsixPreInstall，包 ISVsixPreInstall[5CD0:13EC][2021-05-31T19:42:29]i000: MainViewModel.OnPackageAction:已开始安装 Microsoft SQL Server 集成服务包项目预安装(ID:ISVsixPreInstall)[5CD0:13EC][2021-05-31T19:42:29]i000:MainViewModel.OnPackageActionProgress:完成百分比:100，总体进度:14 [0AEC:278C][2021-05-31T19:42:29]i301:应用回滚包:ISVsixPreInstall，操作:卸载，路径:C:\ProgramData\Package缓存\BB952DD82F1ADAE438C26E4EE6C94F84C07CB447\ISVsixPreInstall.exe，参数: '"C:\ProgramData\Package缓存\BB952DD82F1ADAE438C26E4EE6C94F84C07CB447\ISVsixPreInstall.exe"/instanceIds:2904af6a,6f5e5ef0"；/log:C:\Users\Luigi\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20210531194052_0_ISVsixPreInstall.log"/u' [5CD0:13EC][2021-05-31T19:42:29]i000:MainViewModel.OnPackageAction:Microsoft 软件包的安装已完成SQL Server 集成服务项目预安装(ID:ISVsixPreInstall) [5CD0:13EC][2021-05-31T19:42:29]i319:已应用回滚包:ISVsixPreInstall，结果:0x0，重启:无[0AEC:278C][2021-05-31T19:42:29]i329:删除了包依赖提供者:ISVsixPreInstall，包:ISVsixPreInstall[0AEC:278C][2021-05-31T19:42:29]i351:删除缓存包:ISVsixPreInstall，来自路径:C:\ProgramData\Package缓存\BB952DD82F1ADAE438C26E4EE6C94F84C07CB447
[5CD0:13EC][2021-05-31T19:42:29]i000:MainViewModel.OnPackageActionProgress:完成百分比:100，总体进度:100 [0AEC:278C][2021-05-31T19:42:29]i330:删除捆绑依赖提供者:{ab4889d7-79a3-40dc-9c9e-ccbeca99d453}[0AEC:278C][2021-05-31T19:42:29]i352:删除缓存包:{ab4889d7-79a3-40dc-9c9e-ccbeca99d453}，来自路径:C:\ProgramData\Package Cache{ab4889d7-79a3-40dc-9c9e-ccbeca99d453}
[5CD0:13EC][2021-05-31T19:42:29]e000: MainViewModel.OnBundleAction:捆绑操作失败:未知错误 (0x80131500) (0x80131500)[5CD0:13EC][2021-05-31T19:42:29]i399:申请完成，结果:0x80131500，重启:无，ba请求重启:无[5CD0:4D80][2021-05-31T19:48:12]i000:MainViewModel.OpenUrl:开放网址:C:\Users\Luigi\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20210531194052.log[5CD0:4D80][2021-05-31T20:04:01]i000:MainViewModel.OpenUrl:开放网址:C:\Users\Luigi\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20210531194052.log

[5CD0:13EC][2021-05-31T19:42:29]i319: Applied execute package: ISVsix, result: 0x80131500, restart: None [5CD0:13EC][2021-05-31T19:42:29]e000: Error 0x80131500: Failed to execute EXE package. [0AEC:278C][2021-05-31T19:42:29]i329: Removed package dependency provider: ISVsix, package: ISVsix [0AEC:278C][2021-05-31T19:42:29]i351: Removing cached package: ISVsix, from path: C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7
[0AEC:278C][2021-05-31T19:42:29]i326: Removed dependency: {ab4889d7-79a3-40dc-9c9e-ccbeca99d453} on package provider: ISVsixPreInstall, package ISVsixPreInstall [5CD0:13EC][2021-05-31T19:42:29]i000: MainViewModel.OnPackageAction: Install Started for package Microsoft SQL Server Integration Services Projects Pre Install (id: ISVsixPreInstall) [5CD0:13EC][2021-05-31T19:42:29]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 14 [0AEC:278C][2021-05-31T19:42:29]i301: Applying rollback package: ISVsixPreInstall, action: Uninstall, path: C:\ProgramData\Package Cache\BB952DD82F1ADAE438C26E4EE6C94F84C07CB447\ISVsixPreInstall.exe, arguments: '"C:\ProgramData\Package Cache\BB952DD82F1ADAE438C26E4EE6C94F84C07CB447\ISVsixPreInstall.exe" /instanceIds:"2904af6a,6f5e5ef0" /log:"C:\Users\Luigi\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20210531194052_0_ISVsixPreInstall.log" /u' [5CD0:13EC][2021-05-31T19:42:29]i000: MainViewModel.OnPackageAction: Install Completed for package Microsoft SQL Server Integration Services Projects Pre Install (id: ISVsixPreInstall) [5CD0:13EC][2021-05-31T19:42:29]i319: Applied rollback package: ISVsixPreInstall, result: 0x0, restart: None [0AEC:278C][2021-05-31T19:42:29]i329: Removed package dependency provider: ISVsixPreInstall, package: ISVsixPreInstall [0AEC:278C][2021-05-31T19:42:29]i351: Removing cached package: ISVsixPreInstall, from path: C:\ProgramData\Package Cache\BB952DD82F1ADAE438C26E4EE6C94F84C07CB447
[5CD0:13EC][2021-05-31T19:42:29]i000: MainViewModel.OnPackageActionProgress: Percent completed: 100, Overall progress: 100 [0AEC:278C][2021-05-31T19:42:29]i330: Removed bundle dependency provider: {ab4889d7-79a3-40dc-9c9e-ccbeca99d453} [0AEC:278C][2021-05-31T19:42:29]i352: Removing cached bundle: {ab4889d7-79a3-40dc-9c9e-ccbeca99d453}, from path: C:\ProgramData\Package Cache{ab4889d7-79a3-40dc-9c9e-ccbeca99d453}
[5CD0:13EC][2021-05-31T19:42:29]e000: MainViewModel.OnBundleAction: Bundle action failed: Unknown error (0x80131500) (0x80131500) [5CD0:13EC][2021-05-31T19:42:29]i399: Apply complete, result: 0x80131500, restart: None, ba requested restart: No [5CD0:4D80][2021-05-31T19:48:12]i000: MainViewModel.OpenUrl: Opening url: C:\Users\Luigi\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20210531194052.log [5CD0:4D80][2021-05-31T20:04:01]i000: MainViewModel.OpenUrl: Opening url: C:\Users\Luigi\AppData\Local\Temp\SsdtisSetup\Microsoft.DataTools.IntegrationServices_20210531194052.log

这里只有 ERROR 行:

And here only the ERROR rows:

[0AEC:278C][2021-05-31T19:42:29]e000:错误 0x80131500:进程返回错误:0x80131500 [0AEC:278C][2021-05-31T19:42:29]e000:错误0x80131500:无法执行 EXE 包.[5CD0:13EC][2021-05-31T19:42:29]e000:错误 0x80131500:未能配置每台机器的 EXE 包....[5CD0:13EC][2021-05-31T19:42:29]e000:错误 0x80131500:未能执行EXE包.... [5CD0:13EC][2021-05-31T19:42:29]e000:MainViewModel.OnBundleAction:捆绑操作失败:未知错误(0x80131500) (0x80131500)

[0AEC:278C][2021-05-31T19:42:29]e000: Error 0x80131500: Process returned error: 0x80131500 [0AEC:278C][2021-05-31T19:42:29]e000: Error 0x80131500: Failed to execute EXE package. [5CD0:13EC][2021-05-31T19:42:29]e000: Error 0x80131500: Failed to configure per-machine EXE package. ... [5CD0:13EC][2021-05-31T19:42:29]e000: Error 0x80131500: Failed to execute EXE package. ... [5CD0:13EC][2021-05-31T19:42:29]e000: MainViewModel.OnBundleAction: Bundle action failed: Unknown error (0x80131500) (0x80131500)

推荐答案

经过几个小时的尝试找出我的安装失败的原因后，我发现有人建议通过 VS 安装程序修复 Visual Studio 安装的帖子，我做到了，当然，这意味着环境将恢复为新环境，但它解决了我的问题.

After hours trying to figure out why my installation was failing, I found a post where someone suggested to repair Visual Studio installations via VS Installer, I did it, of course this meant that the enviroment was going to be restored as new, but it solved my issue.

我希望这可以帮助你朋友，祝你有美好的一天！

I hope this could help you friend, have a nice day!

这篇关于SSIS(SQL Server 集成服务)安装失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！