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:
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.