SSIS 2008 R2 -“Excel连接管理器”失败，错误代码为0xC0202009

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

在微软10月份的补丁应用到服务器上之后，我们将面临以下错误。

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

我们将Run64BitRunTime设置为false，将DelayValidation设置为excel文件夹的True和changed路径。仍然面临以下问题。

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.

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

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

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).

在受支持的文件格式和数据库存储库(如SQL Server)之间传输数据。例如，使用SQL Server导入和导出向导或SQL Server集成服务将数据从Excel工作簿传输到SQL服务器(提供SSIS作业在登录用户与有效的HKEY_CURRENT_USER registry hive的上下文中运行)。

2 个解决方案

#1

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

原因是微软本月发布的安全补丁很少。确切地说，它们是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

参见下面的线程中讨论的其他解决方案。

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

“来自外部数据库驱动程序的意外错误(1). (Microsoft JET数据库引擎)”

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

ODBC Excel驱动程序由于“来自外部数据库驱动程序的意外错误(1)”而停止工作。

#2

The solution we are implementing is opening the SSIS package and changing the version of excel file the connection manager produces to anything besides 97-03. You will have to download and install the Microsoft.ACE.OLEDB.12.0 connector for 07-2010 and Microsoft.ACE.OLEDB.16.0 for anything newer.

我们正在实现的解决方案是打开SSIS包并将连接管理器生成的excel文件的版本更改为97-03之外的任何版本。你必须下载并安装微软。ac . oledb .12.0连接器，适用于07-2010和微软。ac . oledb .16.0。

#1