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.
| Author |
Topic |
|
sreehari
Starting Member
37 Posts |
 Posted - 2006-05-29 : 08:02:38
|
| hiwhen i am trying to copy the data from emp table in SQL Server to Oracle 9i,using export wizard, i am getting the following error when the DTS package was run.I am using SQL query as a souce data in SQL Server.The query is..select top 5* from emp;ODBC Error .Table or view does not existsPls help on this issue.Thanks i advance. |
|
|
psawant
Starting Member
14 Posts |
Posted - 2006-05-31 : 09:28:58
|
| First create the table in Oracle then do a simple dts from table to table, this should work fine. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-05-31 : 09:52:31
|
| psawant,Welcome to sqlteam.com!Hope to see more from you here.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
DTS from SQL Server to ORACLE failing