Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Import Oracle to SQL problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-08 : 17:20:18
Susan Jeffries writes "I am having difficulty getting data from an Oracle db to import into our SQL7.0 via DTS. If I simply try to copy one table and all of its data using the "identity insert" option I get an unspecified error. The DSN is working fine because the table is actually created with the appropriate data types. No data is imported however....error something like "Error at Row 1, unspecified error". I have tried just importing a single field (varchar and int) and the problem still exists so I don't think it is a conversion problem. Any helpful suggestions as I hammer away?

Thanks!"
   

- Advertisement -