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 |
|
d_passionate
Starting Member
1 Post |
 Posted - 2006-11-21 : 16:24:51
|
| Hi,I am trying to move some data from Oracle 8 to SQL server 2000. I am using a DTS package to do that. Now the problem is I am not able to create connection to Oracle DB. I tried creating with "MS ODBC connection for oracle", but it didn’t work. I then tried other connections, then it connected, but when i tried to create a task it only show list of table in "Query build", but doesn’t give me any drag drop facility or show me any field. I then tried with paste query and then "transformation" doesn’t work. I am new to DTS, Can anyone help me with these questions.1. How to move data from Oracle DB to SQL server2000. 2. Is it possible to have result of one query/table to be exported to multiple tables?3. What is the performance in DTS for exporting million records?I appreciate your support on the same. Thanks in advance.Cheers,D. |
|
|
|
|
|
Unable to Connect to Oracle in DTS