Hi,All: Once SSIS Error for Export Excel,All Export excel function are fail,can you help me ? Timestamp: 2/21/2011 8:56:48 PM Message: Package error:----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: "Unspecified error". ----SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ExcelConnection" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. ----component "Excel Destination" (107) failed validation and returned error code 0xC020801C. ----One or more component failed validation. ----There were errors during task validation. yanglp

Hi yanglp, When does the error occur? On the first file, in the middle or else? Also, did the package run in BIDS, and not after you deployed it, does not? We need to know specifics to direct you into the right path. For now (on the surface) your path is not set right (the connection to the file) or the package has no rights to access the files (typical for a package running under SQL Server Agent).Arthur My Blog