Hi all,

Just recently our SQL server (2k) has started to fail when attempting to run the DTS wizard.

If the DTSWiz is run from the MMC, the mmc crashes. If it is run explicitly, DTSWiz crashes.

On occasion, the wizard will start, but fail when I try to connect to the source machine with the (approx) error:

"Invalid Syntax"

followed by:

"You have not selected a provider, please select a valid provider to continue"

I've tried installing SP2, tried installing a second instance of SQL server, and also tried manually replacing DTSWiz.exe from the CD. No joy!

I'm starting to pull my hair out - heeeelllp!

TIA - Mike