CODEWITHSUNDEEP
sql-serverexcelssisetl
Ab Bennett
Ab Bennett

Reputation: 1432

SSIS Error with Excel Connection

I have a problem with an SSIS job all of a sudden complaining about an excel connection. The only thing that has happened is a windows update which i would assume is the cause.

The excel connection is with in a data flow task, and there are actually 8 connections that open the same excel file but different wok sheets withing the file and union all them together into a SS table.

Have searched high and low for answers, and have my usual steps to try fix this, but can't solve this one, so just after any ideas.

One interesting thing is it works when running from my desktop using visual studio 2010 but not on the ssis server .

my usual methods which have not worked are.

1.) set delay validation to false for excel connection

2.) set delay validation to false for the data flow task which houses the error.

3.) set maximum concurrent tasks for 1.

4.) make sure and verify job running at 32 bit.

Error: 0xC0202009 at LoadReportingTables_POC, Connection manager "Excel Connection Manager": SSIS 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).". Error: 0xC020801C at PnLExtract, Aviation [92]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with

also get this

Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Unexpected error from external database driver (1).".

Upvotes: 1

Views: 6765

Answers (1)

Hadi
Hadi

Reputation: 37368

I think that you should download the Microsoft Access Database Engine to solve this problem.

Download Links:

Upvotes: 1

Related Questions