Error 0xc0202009 for importing access97 into sql

We have an Access97 database with 122 tables. I try to use import and export wizard to import the data from access into SQL 2005 database. I find an interesting problem. When select all tables, the wizard give following errors:

Pre-execute (Error)
Messages
Error 0xc0202009: {DBD1EAB5-7865-4B89-A7BB-DDC8507D8119}: 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 - PlanClasses" (5206) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard)
But if I divide importing as 2 steps:
1. import all tables before PlanClasses, it works.
2. import all tables after PlanClasses including PlanClasses, it works.

If I just import PlanClasses itself, it works, but I can not import all tables at once. Interesting thing is if I just unselect PlanClasses, it will have same error at the class right after PlanClasses. Is there size limitation when doing import at once?

Yes, unfortunately the wizard does not scale too well when you transfer many tables at once. It generates a single data flow task with as many sources and destinations as is the number of transferred tables. That makes such packages exhaust resources when the number of tables grows.

We have an optimization in place, which builds simple data flows on the fly for each table, but that only works for SQL Server to SQL Server transfers.

Thanks.

|||Will this problem be fixed at SP1? Thanks.
|||

No, unfortunately it is not likely for this to be addressed before the next major product version.

You are welcome though, to put your feedback on the MSDN Feedback site; the more requests for this we get the better chance is to be addressed earlier.

Thanks.