Monthly Archives: October 2017

SSIS – Unexpected error from external database driver – MS Jet database engine

A recent Windows 2012 OS roll up patch causes the execution of any SSIS package to fail under the following conditions:
1. The package is using Microsoft.Jet.OLEDB.4.0
2. The Package is executed from a SQL job.
3. The OS is Windows 2012 on which the SQL is installed.

Snapshot of the error message:

 

 

 

 

 

MS has acknowledged the issue. Below link with details and workaround.

https://support.microsoft.com/en-us/help/4041692/windows-server-2012-update-kb4041692.

Advertisements
%d bloggers like this: