"dangerous MSI" Microsoft SQL Server 2000 DTS Designer Components

Microsoft SQL Server 2000 DTS Designer Components has cause a total destruction of my Enterprise Manager.

In my workstation I've got Sql Server 2000 client and Sql Server 2005 client. Everything goes fine up to here.

But when I've installed that MSI I have not been able to open my Enterprise Manager.

From MMC appears: Error initializing component CLSID: {xxx.xxx}

My goal was be able to open 2000 stuff from Sql Management Studio. By the moment, I'm forget of that.

Does anyone have ever faced this issue?

QA is working.

Thanks in advance for any suggestion

is this an issue? I'm not worried about -I have multiple TS-. But I don't know if it's strongly related with my own workstation settings or is some more general.

My idea was to allow anyone use Sql Management Studio for Sql25k stuff and Sql2k stuff to the full (it included dts 2000) and so and cutting out time.

|||hey guys any ideas?|||

I know, such a pain, day in day out but I can't believe that anyone has ever experimented...

|||Install sp4 on the client. That fixed the problem for me.|||SP4 for Sql Server 2000, you mean?|||First, if you had 2000 client tools and 2005 client tools installed you did not need to install the "DTS designer tools". First thing to do is uninstall it. You only need to install that package if you DON'T have 2000 client tools.

Then, figure out why you are getting the error "You need DTS Designer Tools" when you try to open DTS in 2005.

I found I had SQL 7, 2000 and 2005 client tools installed. If I uninstalled the 7 client tools, the DTS started working.

Also, make sure you have SP4 of 2000 installed on your machine.