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