Systems Engineering and RDBMS

The Export/Import Wizard

Posted by decipherinfosys on January 5, 2010

A client recently migrated from their SQL Server 2000 platform.  Yeah, I know – it took them quite some time to decide to move to SQL Server 2005 but then SQL Server 2008 was just around the corner and things kept getting pushed.  One of the questions that was asked by the client was about the Export/Import Wizard since they did not see that option anywhere in the menu options.  The wizard is still there.  There are a couple of different ways to access it.  The easiest would be to open up SSMS and then right click on the database, select Tasks and under it select the “Import Data” or “Export Data” option depending upon what you want to do:

Once that is done, you will get the wizard.

The steps are fairly straightforward and anyone who had used it in prior versions would be familiar with the steps so we are not covering those in this post.

Another way to start the wizard is to just invoke the exe itself.  If your paths are set up right, then you can go to Start/Run and then type DTSWizard.exe and the Export/Import Wizard will come up.  It’s location is:  X:\Program Files\Microsoft SQL Server\90\DTS\Binn (where X is the drive name where you did the install).

You can also invoke it from BIDS if you want to.  So, the wizard is still there, it is just not accessible in the same way as it used to be in prior versions.  It is a very powerful tool and comes in very handy for getting the data in and out of the system on an adhoc basis.  Also, if you are new to SSIS, this would be a good way to create a package via the wizard, open it up in BIDS and go through the different steps.  Do note that in SQL Server 2008, the Wizard is available from the Start/All Programs/Microsoft SQL Server 2008 option as well.

We have other posts also related to SSIS on our blog including one that discusses the differences between DTS and SSIS – you might find them useful for your work.  We had also compiled the resources for the DTS to SSIS migration – you can access them here.  It also has links to other very useful material available on the net.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: