export/import

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

othellomy@yahoo.com - 27 Feb 2007 06:50 GMT

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!

Reply to this Message

Dan Guzman - 27 Feb 2007 13:33 GMT

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.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

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

Reply to this Message

othellomy@yahoo.com - 28 Feb 2007 08:52 GMT

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
[quoted text clipped - 20 lines]
>
> - Show quoted text -

Okay thanks!

Reply to this Message