SSIS 2008 R2 - "Excel Connection Manager" failed with error code 0xC0202009

We encounter an error after Microsoft October patches appeared on the server.

We set Run64BitRunTime to false and DelayValidation to True and changed the path to the excel folder. The question is still below.

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.

A workaround from under the link resolved this problem on local machines. But on the UAT server, it does not work as expected. And the reason may be below the highlighted information on the link. Any suggestion on how to implement this bold highlight? https://www.microsoft.com/en-us/download/details.aspx?id=13255

Transferring data between supported file formats and a database repository such as SQL Server. For example, to transfer data from an Excel workbook to SQL Server using the SQL Server Import and Export Wizard or SQL Server Integration Services ( assuming that the SSIS jobs are running in the context of a registered user with a valid registry hive HKEY_CURRENT_USER ).

+4
source share
2 answers

The reason for this is the small number of security patches that Microsoft released this month. To be precise, these are KB4041693 and KB4041687.

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

See other solutions also discussed in the following threads.

" (1). (Microsoft JET Database Engine)"

ODBC Excel " (1). (Microsoft JET Database Engine)"

+1

, , SSIS excel, , - 97-03. Microsoft.ACE.OLEDB.12.0 07-2010 Microsoft.ACE.OLEDB.16.0 - .

+1

Source: https://habr.com/ru/post/1688050/


All Articles