Errors after installing Server 2000 DTS Designer Components

Hello,

After Having installed the SQL Server 2000 DTS Designer Components necessary
to edit legacy DTS packages on 2005 server, I keep getting the following message when trying to open SQL Server 200 Enterprise Manager:

"The procedure entry point
?ProcessExecute@.@.YAXPAUHWND_@.@.PBG1@.Z could not be located in teh dynamic link library SEMSFC.dll."

Is there a way to fix so that I can open Enterprise manager?

Thanks!

If you have both SQL 2000 and 2005 client tools installed, you do not need the "SQL Server 2000 DTS Designer Components" package installed.

First, uninstall them. Then figure out why 2005 is telling you to install them, when you don't need them.

Make sure you have run 2000 SP4 on your CLIENT machine to update the tools to the current version.

In my case, the error appears to be related to having SQL 7 client tools installed. When I uninstalled them the error in 2005 went away.

|||

Thanks for the info. I really appreciate it.

|||

Good info. Fixed what I thought was a very cryptic error message.

Thanks for the details!

|||

Tom,

How do you install SP4 on a client machine. How do you specify the instance and user id if I don't have one installed on my machine?

Thanks,
Joseph