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 |
|
yipchunyu
Yak Posting Veteran
80 Posts |
 Posted - 2008-06-12 : 02:10:19
|
| We are using SQL 2000 server and use the DTS to import data from text file, Oracle database.Since SQL 2000 server will not be supported in the near future. We would like to change the DB to oracle.Any tools provide the same functions as DTS in Oracle?Pls advice.Thx |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-12 : 03:26:37
|
quote:
Originally posted by yipchunyu
We are using SQL 2000 server and use the DTS to import data from text file, Oracle database.Since SQL 2000 server will not be supported in the near future. We would like to change the DB to oracle.Any tools provide the same functions as DTS in Oracle?Pls advice.Thx
You have SSIS available in SQL 2005 which does same functions (or even advanced) of DTS. |
 |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2008-06-12 : 11:59:44
|
| http://www.oracle.com/technology/products/warehouse/index.html |
|
|
|
|
|
|
Any thing similar to DTS in Oracle