Issue with DTS from Sql25k

Hi everyone,

I understand that this is an issue. Microsofts doesn't inform anywhere

When you've got in your workstation both Sql2k and Sql25k clients and try to install the package for design dts 2000 from Sql25k then you'll not be able to re-start your Enterprise Manager from

MMC.

Appears this error:

?ProcessExecute@.@.YAXPAUHWND_@.@.PBG1@.Z dynamic link library procedure start point is not founded (SEMSFC.DLL)

Query Analyzer starts as usual, without problems but you lose your EM.

TIA

If you have both 2000 and 2005 client tools installed, you do not need the "SQL 2005 Compatibility DTS tools" installed. First, uninstall them. Then figure out what is causing your other error, that says you need to install them.

My problem seems to have been the SQL 7 client tools were also installed, so I had 7, 2000 and 2005. This confused 2005. As soon as I uninstalled the SQL 7 client tools, the error went away and I was able to run the DTS designer in 2005.|||

Hi Tom,

Thanks for your response. I get the point but at least it could be reported.

|||What it really need to do is give you a valid error message, instead of "install DTS components" which you don't need to do. :) If it said "could not find xxxxx" or "error in .DLL" or something, then it wouldn't lead people, including myself, down the wrong path.