Posted by Dan Guzman on 02/27/07 13:33

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

<othellomy@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!
>

[Back to original message]