SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-04-2008, 06:23 AM
| ||||
| ||||
 where is import and dts on sql server 2005 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      |
|
03-04-2008, 06:23 AM
| ||||
| ||||
| Re: where is import and dts on sql server 2005 kishjeff (kishjjrjj@charter.net) writes: > 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? 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. > If not, are there any other ways to import into the system using some > other method? 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@sommarskog.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 |
Linear Mode
