I have created a package(SSIS) with multiple Data Flow Tasks, I run this package through the SQL Server Agent everyday. Today the package failed after 4min at a Data Flow Task that's almost at the finish of the pakage. I restarted the job and it failed within 6seconds, the error I got is:
Code: 0xC0202009 Source: AllSuppliers OLE DB Destination  Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2008-07-09 09:54:32.19 Code: 0xC0209029 Source: AllSuppliers OLE DB Destination  Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (364)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (364)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. End Error Error: 2008-07-09 09:54:32.19 Code: 0xC0047022 Source:... The package execution fa... The step failed.
What the Data Flow Tasks do is to send SQL Tables to Access, the first step of the Package is to clean all the Tables in Access.
What causes this unexpected problem?