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!

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 (AT) yahoo (DOT) com> wrote

On Feb 27, 7:33 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.net> wrote:
Okay thanks!