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.

Error "Failed to Export the Report"

Using Crystal Reports 8.5, RDC, VB6, Win2k for both Dev and client

I'm trying to export a report to pdf, but keep getting:

Error -2147190908 (80047784) "Failed to Export the Report"

It exports fine on my Dev machine, but not on the client machine. I've earched the internet high and low for the answer. The only thing I found was a missing or incorrectly registered ExportModellar.dll and crtslv.dll. I verified that both of those files as well as the correct Destination and ExportType dlls are installed and registered properly. I even reinstalled CR 8.5 on that machine! I have no idea what to try next!

I even downloaded Crystal's Modules utility that supposed to tell you the differences between the dlls being used on 2 different machines. ExportModellar was version 8.5 on the client machine and version 9.1 on my machine, so I upgraded ExportModellar to 9.1 on the client machine, but it didn't help.

Any thoughts would be greatly appreciated!

Thanks in advance.^^^
I have the exact same problem but am using crystal 7 on windows server 2003
Everything seems fine on my machine but not on the client machines.
did you manage to solve this problem, or does any1 have any ideas?|||I finally did get it to work. I ended up downloading a hotfix and installing it on that machine. I still don't know what file was messed up.

Good luck and sorry I couldn't be of any more help!

Malleyo|||sorry to ask another question but what hot fix did you download and where did you get it from?
thanks in advance|||I don't remember which hotfix I used. Try searching Crystal Reports website:
http://support.businessobjects.com/search/advsearch.asp|||I don't remember which hotfix I used. Try searching Crystal Reports website:
http://support.businessobjects.com/search/advsearch.asp
I had the same problem. The hotfix can be found at http://support.businessobjects.com/communityCS/FilesAndUpdates/dbexdrvrwin_en.zip.asp

Roy DeWitt|||I am haing the same problem but the patch did not fix the problem...does anyone have any other ideas? We are running Crystal Report 7 on 2003 operating system.|||For this type of problems you need to make sure that the system is updated with latest patches if any

error - microsoft jet database engine can not find the object tabble_name

Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
--
Thank you very much!
Best regards,
FlorenceHi Forence,
Florence Lee wrote:
> I try to export my data from sql server to excel, when i preview the
> data, it all runs fine. When i run export, it prompt me this error. How can
> i ensure this object is exist? and how do i verify this error? In the
> enterprise manager, i can view the records for my table.
If you can use the Enterprise Manager to view your table records, you
may want to consider just using the EM to export your table to a comma
delimited file. You should be able to do this by using the "export"
task from within the Enterprise Manager, using the DTS wizard. Once you
have the comma delimited file, you can then use Excel to import that.
It's a workaround, but a workaround that should work for you. :)
Hope this helps.|||Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
--
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...
> Hi Forence,
> Florence Lee wrote:
> > I try to export my data from sql server to excel, when i preview
the
> > data, it all runs fine. When i run export, it prompt me this error. How
can
> > i ensure this object is exist? and how do i verify this error? In the
> > enterprise manager, i can view the records for my table.
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you. :)
> Hope this helps.

error - microsoft jet database engine can not find the object tabble_name

Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
Thank you very much!
Best regards,
Florence
Hi,
I try to use the dts to direct export to excel, come out this error why?
I dun want to export to text files then just back to excel.
Thank you very much!
Best regards,
Florence
"William R. Lorenz" <wrl@.express.org> wrote in message
news:eFoSj5K6EHA.3944@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Hi Forence,
> Florence Lee wrote:
the[vbcol=seagreen]
can
> If you can use the Enterprise Manager to view your table records, you
> may want to consider just using the EM to export your table to a comma
> delimited file. You should be able to do this by using the "export"
> task from within the Enterprise Manager, using the DTS wizard. Once you
> have the comma delimited file, you can then use Excel to import that.
> It's a workaround, but a workaround that should work for you.
> Hope this helps.