posted on Friday, June 10, 2005 9:16 AM by Knight_Reign

Where'd the Wizard go...

Weather'ed DTS users will know it as _The_ Wizard and wonder from where it can be launched. The Import/Export Wizard is no longer on the main start menu. I don't know why, but for some reason the powers that be decided that it would be better to not have the Import/Export Wizard on the start menu. 

If you're one of those folks that uses the Import/Export Wizard a lot and would like to have it available instantly, do what I did and put it on your start menu or in my case the Quick Launch bar.

  1. Open the folder where IS is installed (Unfortunately, still called DTS). On my machine it's at : C:\Program Files\Microsoft SQL Server\90\DTS\Binn
  2. Right click and drag/drop it to the task bar in the quick launch toobar.
  3. When the context menu pops up, select Create a shortcut here.
  4. Done

You can do the same with the start menu. Also, the other IS binaries are there as well. DTExecUI, DTExec, DTUtil, and the Migration Wizard.

Universe.Earth.Software.Microsoft.SQLServer.IS.KirkHaselden  

Comments

# re: Where'd the Wizard go... @ Friday, August 12, 2005 8:41 AM

Hiya,
Not meaning to be pedantic but you didn't actually give the name of the .exe!!!

-Jamie

Jamie Thomson

# re: Where'd the Wizard go... @ Friday, August 12, 2005 8:42 AM

Which by the way is DTSWizard.exe (for anyone else that is reading)

:)

Jamie Thomson

# re: Where'd the Wizard go... @ Sunday, August 14, 2005 11:48 PM

Horrible oversight. Thanks for the correction, Jamie.

Knight_Reign

# re: Where'd the Wizard go... @ Thursday, November 17, 2005 4:02 AM

Hey fella, you think you could email me the exe's (all the dts dir) as my release (the latest from MS misses these essential components out)

Thanks

Anthony Main