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 |
|
bspahr75
Starting Member
5 Posts |
 Posted - 2008-10-10 : 16:52:43
|
| In SQL Server 2000 Enterprise Manager it was very easy to import a table with the DTS Wizard. My hosting company is now using SQL Server 2005. I just installed Sql Server Management Studio Express but cannot find this option. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-10 : 16:57:02
|
| Express versions dont have that option.By the way, in 2005 and 2008 its called SSIS |
 |
|
|
parag.sv
Starting Member
11 Posts |
Posted - 2008-10-11 : 18:38:53
|
| Adding on to afrika...The SSIS package completely different from the DTS of 2000.You wont find something called as SSIS package in your Program Menu...Drill down like this --> Start --> Program --> Microsoft SQL server 2005 --> SQL Server Business Intelligence Developemen Studio.Here select "Integration Services Project" .... give the location where you want to stored your project..and then Start Designing the package as per your requirement.ThanksPara |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-12 : 02:42:21
|
| In SQL 2005 express, the export import wizard comes seperately with SQL Express Edition toolkit. you can install it and then use the dtswizard utility to transfer data b/w tables or heterogenous sources.http://mobiledeveloper.wordpress.com/2007/01/31/data-import-export-with-sql-server-express-using-dts-wizard/ |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-12 : 02:48:44
|
| Best option is to purchase MS SQL developer edition.Acutally, the express version is an upgrade or replacement of MSDE versions. And the equivalent of what you were using, prior to the upgrade, is the developer edition |
|
|
|
bspahr75
Starting Member
5 Posts |
Posted - 2008-10-15 : 17:07:54
|
| Well, that explains alot then! Thanks for the replys. |
|
|
|
|
|
|
Sql Server Management Studio Express Import