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 |
|
joni
Yak Posting Veteran
50 Posts |
 Posted - 2005-07-21 : 08:54:24
|
| Hi gurus,I need to make a conection beetwen SQL and Oracle to import same tables from Oracle to SQL but I don´t know how to do this.Any help is very well come.Thank´s in advancedJoni |
|
|
thebruins
Starting Member
31 Posts |
Posted - 2005-07-21 : 09:40:18
|
| create a DTS package and add a 'connection'. select 'microsoft ODBC for oracle' as 'data source'. do the same for the MSSQL server selecting MSSQL as data source.next create a data transform task and set the oracle connection as source and the mssql connection as destination. in the data transform task you can do the actual transfer of the data |
 |
|
|
|
|
|
DTS beetwen SQL 7 and Oracle 8.1