Code 0xC0202009, I can not get this connection manager to play nice. Works fine when run in visual studio

-1

This package executes when run on its own but I encounter this error every time I try to kick it off in SQL -

Code: 0xC0202009 Source: T1 Report Connection manager "Excel Connection Manager" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.". End Error Error: 2019-05-07 16:03:02.79 Code: 0xC020801C Source: Data Flow Task Excel Destination [84] Description: 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. End Error Error: 2019-05-07 16:03:02.79 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: Excel Destination failed validation and returned error code 0xC020801C. End Error Error: 2019-05-07 16:03:02.79 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2019-05-07 16:03:02.79 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:03:01 PM Finished: 4:03:02 PM Elapsed: 0.907 seconds. The package execution failed. The step failed.

Why is this happening? Anyone know how to solve this?

sql-server
excel
ssis
oledb

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0