Jet DB Engine - SSIS OLEDBERROR - Unexpected error from external database driver (1)

▲
2
▼

My SSIS job hosted in DEV server got failed due to the the following SSIS Error

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

In my SSIS package -> Data Flow Task, I am using source as SQL server and destination as Excel. Excel Version is 97-2003 (xls format) and the connection details is:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source={mypath}\filename.xls;Extended Properties="EXCEL 8.0;HDR=YES";

It was running successfully every one hour as scheduled.

The issue occurred when DB instances stopped for windows patching and after started on patching completion

I am facing this issue in the server. I have checked other solutions in Stack Overflow. It was mainly discussed with size based. In my case, SSIS job never changed. I believe this is due to Jet engine driver level issue. I am more looking for driver level check rather than ssis job level code change, as the code never changed and no large data flow is happened.

ssis
excel-2003
oledbexception
asked on Stack Overflow Oct 13, 2017 by Viswa • edited Jun 29, 2018 by halfer

6 Answers

▲
4
▼

Same for me after switching to the second node of the cluster after applying wsus updates. Seems to be related to the last updates.

I've filed a connect bug: https://connect.microsoft.com/SQLServer/feedback/details/3142556

Just uninstalled: KB 4040685 (This is on my workstation, too) KB 4041693 KB 4041687

It's working fine now!

answered on Stack Overflow Oct 13, 2017 by Christoph Muthmann • edited Oct 13, 2017 by Christoph Muthmann
▲
2
▼

Same here as well. After applying updates to the server, packages which use Excel 97 - 2003 format have failed.

We are having to switch each connection to 2007 to enable the package to run on the server.

answered on Stack Overflow Oct 13, 2017 by Malice345
▲
1
▼

The best recommended solution is to move to Microsoft ACE OLE DB provider.

Microsoft is working on a resolution and will provide an update in an upcoming release of the security patch. This is expected to be available in another 2-3 weeks or earlier.

More info...

answered on Stack Overflow Oct 18, 2017 by bgarcia
▲
0
▼

I installed Access Database Engine Tools 2010, after this I changed the Excelversion from 2003 tol 2007 in connection. Then I again can execute my extract packages form XLS files, without having to uninstall KB's BR Annette

answered on Stack Overflow Oct 16, 2017 by Annette
▲
0
▼

Change every datasource from "Provider=Microsoft.Jet.OLEDB.4.0" to "Provider=Microsoft.Jet.OLEDB.12.0"

This error ocurs when installed updates: KB4040685, KB4041693, KB4041687

answered on Stack Overflow Oct 16, 2017 by Isaac Sánchez
▲
0
▼

In my case – we have bunch of packages uses older version of excel. Upgrading/Modifying packages is not solution without going thru SDLC process.

As Temp Work Around – We un-installed the security patches - KB4041679 & KB4041690 and things started working.

First, We did uninstalled KB 4040685 and issue still persists.

We are using Microsoft Jet 4.0 OLE DB Provider to read data from Excel(.XLS) file.

Thanks, Sri

answered on Stack Overflow Oct 16, 2017 by Srihari Kagita

User contributions licensed under CC BY-SA 3.0