Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

excel connection error Expand / Collapse
Posted Thursday, November 8, 2012 6:33 AM


Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:01 PM
Points: 149, Visits: 346

i am getting error when connection to excel connection manager

TITLE: Package Validation Error

Package Validation Error


Error at Data Flow Task [Excel Source [28]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Error at Data Flow Task [SSIS.Pipeline]: Excel Source failed validation and returned error code 0xC020801C.

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

Error at NDC [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: "External table is not in the expected format.".




i turned off run64bitruntime,still i am getting error

Post #1382459
Posted Friday, November 9, 2012 12:30 AM



Group: General Forum Members
Last Login: Thursday, November 26, 2015 2:23 AM
Points: 14,840, Visits: 12,893
External table is not in the expected format

Is the Excel file of the correct version?
Which type of Excel file are you trying to load?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1382858
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse