SSIS - "Microsoft JET Database Engine" error - Hresult: 0x80004005 Description: "Unexpected error from external database driver (1)

Bump into this error a couple of days ago. The root causes - Windows Update. To way to resolve this is look at your windows update and check against Microsoft website to see what is the patch about.

For example, KB4041693 provides a list of components affected and possible resolution.

If you cannot quickly repair your connection string from Jet to ACE,. then you might try uninstalling windows updates and restart your machine.  This could be different on your machine, there could be additional updates you need to un-installed compare to the list below :-

KB4041681 - Windows 7 Update 

KB4041693 (Window 8 and Window Server 2012 ) / KB4041678 (Windows 7 and Win 2008 Server)   - Both stated it will affect Microsoft.Jet driver 

SQL-Management studio -> SSIS package -> The specific package -> Report -> All Execution and try to see what other error messages you're getting.

Do not focus on the DRIVERS. Re-installing the database driver is the last option. You should use existing ones - in my case Microsoft Access Engine 2010 - Yeap abit old. :)


Popular posts from this blog

Solving Sonarqube :- Project was never analyzed. A regular analysis is required before a branch analysis

spark - pyspark reading from excel files