SSIS - Excel connection manager
Posted on 2010-09-23
I am not sure what this error is all about. How can i correct it? In Excel Destination Editor, everything look ok to me.
[Excel Destination ] Error: 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.
[DTS.Pipeline] Error: component "Excel Destination" (2457) failed validation and returned error code 0xC020801C.