468,101 Members | 1,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,101 developers. It's quick & easy.

export/import

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!

Feb 27 '07 #1
2 3162
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

<ot*******@yahoo.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.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!
Feb 27 '07 #2
On Feb 27, 7:33 pm, "Dan Guzman" <guzma...@nospam-
online.sbcglobal.netwrote:
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.comwrote in message

news:11**********************@a75g2000cwd.googlegr oups.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!

Feb 28 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

205 posts views Thread by Jeremy Siek | last post: by
2 posts views Thread by mike_dba | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.