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



Comments

Post a Comment

Popular posts from this blog

The specified initialization vector (IV) does not match the block size for this algorithm

Image
If you're getting  exception when trying to assigned key to a symmetric key and getting error message below :- The specified initialization vector (IV) does not match the block size for this algorithm And your code probably look like something below :- Then you need to go into debug mode and start looking into the supported size for IV as shown in diagram below :- As you can see, IV is 16 bytes, so you need to provide 16 bytes. The same goes for Key field too, if you're adding anything to it. As long as you provide a valid key size, then we're good and you're code will be ready.
Read more