Hi.
I used to have sql server 2000 and used dts to import data from oracle
databases.
Now I've been using sql server 2005 express, and don't see how to
import anymore. Is DTS not available with sql server 2005 express?

If not, are there any other ways to import into the system using some
other method?

thanks
Jeff

kishjeff (kishjjrjj (AT) charter (DOT) net) writes:
DTS was vastly remodelled and is in SQL 2005 known as Integration Services,
but Integration Services only ship swith the paid-for editions of SQL
Server.

There always linked servers, although linked servers usually means hassle.

If you are only doing this on a developement basis, you may want find it
worth to get a copy of Developer Editions, which should cost around
50 USD.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx