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 Files\Microsoft SQL Server\90\DTS\Binn. I looked for it there and could not locate it. I didn’t even have a directory ...\DTS\binn. 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.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish