From the Community: Finding the Import and Export Wizard

Q: In last week’s article (“Importing and Exporting Data,” InstantDoc ID 95654, http://www.sqlmag.com/Article/ArticleID/95654/sql_server_95654.html ), you mentioned that we should be able to find the Import and Export wizard in SQL Server 2005 Express Edition at C:Program FilesMicrosoft SQL Server90DTSBinn. I looked for it there and could not locate it. I didn’t even have a directory ...DTSbinn. I have SQL Server Express SP2 installed, but your article indicated the wizard was included in SQL Server Express SP1. I checked there as well and couldn’t locate it. Do you know where I can find it?
A: If you can’t find the Import and Export Wizard (Dtswizard.exe) on your SQL Server Express system, try downloading the SQL Server Express Toolkit SP2 from:

http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en

While installing the toolkit, be sure to select the Business Intelligence Development Studio option.