SSIS 2008 R2-"Excel连接管理器"失败，错误代码为0xC0202009 [英] SSIS 2008 R2 - "Excel Connection Manager" failed with error code 0xC0202009

问题描述

在服务器上应用了Microsoft的10月补丁后，我们面临以下错误.

We are facing below error after Microsoft's October patches applied on the server.

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

We have set Run64BitRunTime to false and DelayValidation to True and changed path of the excel folder. Still facing below issue.

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/zh-cn/download/details.aspx?id = 13255

Workaround from below link resolved this issue in local machines. But In UAT server, it is not working as expected. And the reason could be below highlighted info from the link. Any suggestion on how to implement this bold highlighted? 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注册表配置单元的登录用户的上下文中运行).

To transfer data between supported file formats and a database repository, such as SQL Server. For example, to transfer data from an Excel workbook into SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services (provided the SSIS jobs run in the context of a logged-on user with a valid HKEY_CURRENT_USER registry hive).

推荐答案

原因是Microsoft本月发布了一些安全补丁.确切地说，它们是KB4041693& KB4041687.

The reason for this is few security patches released by Microsoft this month. To be precise they are KB4041693 & KB4041687.

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

It started working for me when I removed these patches. but this is not recommended solution.

请参阅以下线程中讨论的其他解决方案

See other solutions as well discussed in following threads

十月安全更新后，来自外部数据库驱动程序的意外错误(1).(Microsoft JET数据库引擎)

这篇关于SSIS 2008 R2-"Excel连接管理器"失败，错误代码为0xC0202009的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！