dbTalk Databases Forums  

Error 80040E37 when Exporting Tables To Oracle

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Error 80040E37 when Exporting Tables To Oracle in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
David Grant
 
Posts: n/a

Default Error 80040E37 when Exporting Tables To Oracle - 04-13-2005 , 02:22 AM






Hello to Everybody,

I've been using the Export/Import DTS wizard to export some tables
(40) from my database to an Oracle instance. The process is quite long
(about 8 hours) and it exports successfully the vast majority of the
tables. However, I've found that, near the ending of the process, some
tables (6) have not been exported due to this error:

Step Error Origin : Microsoft OLE DB Provider for SQL Server
Step Error Description: The name of the object
'Database01_CDR.dbo.CDR_CARDS' is invalid.
Step Error Code: 80040E37

Given that I've reading about this issue before posting, I've checked
who's the owner of the whole set of tables (it's "dbo") and the tables
exist 'physically' there. Furthermore, the rest of the tables (34)
are exported without problems.

In SQL Server 2K the tables are created at the same time by an SQL DTS
Task.

Any help will be wellcomed.

Greetings,
David Grant

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.