| 
 Posted by othellomy on 02/28/07 08:52 
On Feb 27, 7:33 pm, "Dan Guzman" <guzma...@nospam- 
online.sbcglobal.net> wrote: 
> The import/export wizard is available from SQL Server Management Studio from 
> the Object Explorer.  Right-click on the a database node and select Tasks 
> and then either Import or Export Data.  The wizard will generate a SQL 
> Server Integration Services (SSIS) package that you can execute and/or save. 
> 
> Note that SSIS is a replacement for the DTS feature found in previous SQL 
> Server versions.  SSIS packages can be created from scratch using SQL Server 
> Business Intelligence Development Studio. 
> 
> -- 
> Hope this helps. 
> 
> Dan Guzman 
> SQL Server MVP 
> 
> <othell...@yahoo.com> wrote in message 
> 
> news:1172559059.922478.114550@a75g2000cwd.googlegroups.com... 
> 
> 
> 
> > What are the ways to export/import data in/out of SQL Server 2005? I 
> > used to use DTS for 2000 to do such thing and now I can't even find 
> > the wizard in 2005!- Hide quoted text - 
> 
> - Show quoted text - 
 
Okay thanks!
 
  
Navigation:
[Reply to this message] 
 |