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

SQL Server 2012, SSIS October 23, 2017 Leave a comment

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.

Advertisement

Tagged: , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: