Due to the maintanance ,the source MsAccess Server goes to down for few hours after few hours the Server Comes Up. However the scheduled jobs failed The log file information for the failed Job. Executed as user: CIT\datawh. ...Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 5:00:00 AM Error: 2011-04-07 05:00:07.00 Code: 0xC0202009 Source: pkg LoadAcessCard Connection manager "Access Card" Description: 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: "Disk or network error.". End Error Error: 2011-04-07 05:00:07.01 Code: 0xC020801C Source: Load stgHolderIOData OLE DB Source [3703] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Access Card" 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: 2011-04-07 05:00... The package execution fa... The step failed. Thanks in Advance... Thiru-BI

did you run this job before this? was it successful? Did you changed anything in sql server agent account? or job step properties which runs ssis package?http://www.rad.pasfu.com

Hi, I did not change anything in in sql server agent account. This failure occured once the source data Server Down after few hours goes to up. Tnks, Thiru-BI

Where ist the Access DB loceted? If on a Network drive, check the permissions and check the connection to the storage place. Maybe the permissions got changes or the networkdrive is not connectetd.

Hi, MSAccess Source is Network Drive. This is already running without any issue. The Problem once shutdown the source system after few hours source system was up. Eventhrough job got failed. Tnks, Thiru-BI

Hi All, That issue was fixed. We can not able to access the shared folder from that source system. However we can able to access by using IP address of the source system. The Problem was System Admin side. Thanks & Regards, Thiru-BI