SSIS Errors

[George1111]

I am converting an Access 2000 MDB Database to SQLExpress 2005 using the SSIS Wizard.

I keep getting an error as follows, even if the Table name is a different table at the "64" point - the database is in fact converted and I can use it, but I am getting this error and am just wondering why. Microsoft knowedgebase is not helpful but I did come across one posting which suggested it could be a timeout problem

If this is the case, I was wondering how to set the timeout parameters for the SSIS Wizard

Thanks for any suggestions

Pre-execute (Error)
Messages
Error 0xc0202009: {ED17B5A9-CEC7-4BBD-ADB3-1FAA16C4ECF8}: 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".
(SQL Server Import and Export Wizard)

Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Source 64 - SERVICE_Items" (15433) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

[George1111]

Here it is again - this time stops on a different table, but again its Table 64

- Pre-execute (Error)
Messages
Error 0xc0202009: {326C9BBC-D6AF-4D2A-97BE-A9E52B5E64FF}: 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".
(SQL Server Import and Export Wizard)

Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)

Error 0xc004701a: Data Flow Task: component "Source 64 - PA_Departments" (15598) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)

[tgolisch]

In SSIS (SQL Server Import and Export Wizard) when you get an error saying something about "Source 64..." or "Destination 64..." it is because SSIS has a limit of 63 tables for import/export. If you have more than 63 tables, you need to use more than one [batch].