sql-server - SSIS 2008 R2 - "Excel Connection Manager"失败，错误代码为 0xC0202009

Question

在服务器上应用 Microsoft 10 月份补丁后，我们遇到以下错误。

我们已将 Run64BitRunTime 设置为 false，将 DelayValidation 设置为 True，并更改了 excel 文件夹的路径。仍然面临以下问题。

Error: 0xC0202009 at SSIS_Document_Report, Connection manager "Excel Connection Manager": SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unexpected error from external database driver (1).".
Error: 0xC020801C at SSIS_Get_Document_Report, Excel Destination [436]: 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: 0xC0047017 at SSIS_Get_Document_Report, SSIS.Pipeline: component "Excel Destination" (436) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at SSIS_Get_Document_Report, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at SSIS_Get_Document_Report: There were errors during task validation.
Warning: 0x80019002 at SSIS_Document_Report: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED.  The Execution method succeeded, but the number of errors raised (5) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "SSIS_Document_Report.dtsx" finished: Failure.

下面链接中的解决方法解决了本地计算机中的此问题。但在 UAT 服务器中，它没有按预期工作。原因可能是链接中突出显示的信息。关于如何实现这个粗体突出显示有什么建议吗？ https://www.microsoft.com/en-us/download/details.aspx?id=13255

在支持的文件格式和数据库存储库(例如 SQL Server)之间传输数据。例如，使用 SQL Server 导入和导出向导或 SQL Server Integration Services 将数据从 Excel 工作簿传输到 SQL Server(前提是 SSIS 作业在具有有效 HKEY_CURRENT_USER 注册表配置单元的登录用户上下文中运行) )。

Answer 1

造成这种情况的原因是微软本月发布的安全补丁很少。准确地说，它们是 KB4041693 和 KB4041687。

当我删除这些补丁时，它开始为我工作。但这不是推荐的解决方案。

查看以下主题中讨论的其他解决方案

"Unexpected error from external database driver (1). (Microsoft JET Database Engine)” after applying October security updates

ODBC Excel Driver Stopped Working with "Unexpected error from external database driver (1). (Microsoft JET Database Engine)"