On my development DTS server, running Windows 2000 server, I have
-d:\Program files\DTSUtilities\Binn\DTSRun.exe, which has a version of
7.00.694
-d:\program files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe (SQL 2000's
version)
(The SQL Enterprise Manager on this box does NOT fully work- cannot open up
any DTS package, when I right click DTS and select Open Package, I get no
response)

On my production DTS server, running Windows 2000 server, I have
-d:\Program files\DTSUtilities\Binn\DTSRun.exe, which has a version of
7.00.623
-d:\program files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe (SQL 2000's
version)
(The SQL Enterprise Manager on this box Does work- I can open up
SQLServer7.0 DTS packages, but not any DTS packages saved from a WinXP Pro
SP1 machine with SQL2K Enterprise manager client).

I am upgrading client to SQL2000. I would like to test out the DTS
connectivity n the dev/test box first, then replicate to production. Not
ideal that SQL7 client version are different, but what is the best way of
un-installing SQL7 DTS Client cleanly? I can't see SQL7 or SQL2000 listed
under Add/Remove Programs.

In message <50565748-C68C-4151-BED1-F93B3B4530DF (AT) microsoft (DOT) com>, Patrick
<questions (AT) newsgroup (DOT) nospam> writes
You can run SQL Server 7 and SQL Server 2000 engines on the same
machine, side by side. When you install SQL 2000, which should be done
after SQL 7, it will upgrade the tools to SQL 2000, and you should no
longer be using the SQL 7 tools. It does leave some 7 files behind, but
if you run DTSRun from a command prompt there is no need to select
either version, the DTRun 2000 version will work for both. The 7 version
still exists, but if you check your environment PATH variable, the SQL
2000 path should appear before the SQL 7 path. Check that this is the
case.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hello,

By default, after installing SQL server 7, dtsrun.exe is located in the
C:\MSSQL7\Binn folder, and the version of the dtsrun.exe may be
1998.11.13.0

After installing SQL server 2000, dtsrun.exe is located in the C:\program
files\Microsoft SQL Server\80\Tools\Binn folder, and the version may be
2000.80.2039.0

I notice that the version of the DTSRun.exe in the folder d:\Program
files\DTSUtilities\Binn\ is 7.00.694. Based on my experience, it might not
be a file of SQL server 7.

In addition, you are unable uninstall dtsrun.exe utility directly because
it comes with the SQL server Client Tools.

The following information is for your reference:

276044 INF: How to Manually Uninstall SQL Server 7.0
http://support.microsoft.com/?id=276044

290991 How to manually remove SQL Server 2000 default, named, or virtual
http://support.microsoft.com/?id=290991

I hope the information is helpful.


Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.