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 |