sql-server - 包验证错误 : 0xC020801C excel connection

Question

我一直在用头撞墙试图弄清楚这一点。我已经设置了两个连接管理器来连接到 Excel 文件上的两个工作表。每个都用于将数据从 SQL DB 导出到工作表。到昨晚为止一直运行良好。现在我得到错误:

===================================

Package Validation Error (Package Validation Error)

===================================

Error at Export Approved Projects to Excel [Excel Dest AllData [293]]: SSIS > > Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error at Export Approved Projects to Excel [SSIS.Pipeline]: Excel Dest AllData failed validation and returned error code 0xC020801C.

Error at Export Approved Projects to Excel [SSIS.Pipeline]: One or more component failed validation.

Error at Export Approved Projects to Excel: There were errors during task validation.

Error at Package [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8007007E. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x8007007E Description: "The specified module could not be found.".

(Microsoft.DataTransformationServices.VsIntegration)

---

Program Location:

at Microsoft.DataTransformationServices.Project.DataTransformationsPackageDebugger.ValidateAndRunDebugger(Int32 flags, IOutputWindow outputWindow, DataTransformationsProjectConfigurationOptions options) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, ProjectItem startupProjItem, DataTransformationsProjectConfigurationOptions options)

at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchActivePackage(Int32 launchOptions)

at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.LaunchDtsPackage(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

at Microsoft.DataTransformationServices.Project.DataTransformationsProjectDebugger.Launch(Int32 launchOptions, DataTransformationsProjectConfigurationOptions options)

我找到了这个答案: Package Validation Error建议更改 Run64Bits至 FALSE .我这样做了，仍然得到同样的错误。

我还找到了一个答案(虽然我不记得链接了)，它说要更新 DelayValidation在连接管理器上到 TRUE .我也这样做了，但仍然得到同样的错误。

然后我找到了这个 The Specified Module could not be found. . .

但它已经 5 岁了，并且谈论它是由卸载 VS2012 引起的。我实际上正在使用 VS2012 编写项目，所以我认为这不是它，还没有尝试过。

还有什么建议？？？

更新

我按照建议替换了 dll 并没有改善。我仍然得到同样的错误。

Answer 1

Microsoft OLE DB Service Components" Hresult: 0x8007007E Description: "The specified module could not be found.".

您可以通过修复 Microsoft Office Database Engine 来解决此问题即使您以前安装过，但似乎卸载某些 Office 产品或类似操作可能会破坏 Excel 连接。