Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server 2000 vs SQL Server 2005 SSIS Import and Export Wizard

By:   |   Last Updated: 2006-10-03   |   Comments   |   Related Tips: More > Integration Services Import and Export Wizard

The SQL Server Import/Export Wizard is a way to either perform a one-time data import/export, or create a DTS/SSIS package that can be further developed.  Because the Import/Export Wizard is a part of Data Transformation Services, it was re-written in SQL Server 2005, as was the entire SQL Server Integration Services process.  Because of this, the methods of accessing the Import and Export Wizard have changed.

In SQL Server 2000 the Import/Export Wizard could be accessed a few ways:

  1. From the Start Menu under the Microsoft SQL Server submenu


  1. By typing dtswiz in either a command prompt or from a Run dialog box

  1. Inside Enterprise Manager.  In order to start the Import/Export Wizard from this location, you must navigate to at least the <server_name> section with the console tree.  Click the Wizard button and the Select Wizard dialog box appears

In SQL Server 2005 the ways to get to the Import/Export Wizard are a little different (the shortcut in the Start Menu/Microsoft SQL Server 2005 submenu was removed):

  1. Type dtswizard in either a command prompt or Run dialog box:

  1. Open the SQL Server Business Intelligence Development Studio (BIDS).  Once open, you must create a new project (File/New/Project).  Click on Business Intelligence Projects (left), click Integrated Services Project (top middle), name the project whatever you wish, and click OK:

  1. Once the SSIS Designer window is open, click Project/SSIS Import and Export Wizard

Next Steps

Last Updated: 2006-10-03

get scripts

next tip button

About the author
MSSQLTips author Edgewood Solutions Edgewood Solutions is a technology company focused on Microsoft SQL Server and founder of MSSQLTips.com.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools