In message <A33B3598-8F0C-45FC-958C-292B61DB313F (AT) microsoft (DOT) com>, Mike
Mahon <mike.mahon (AT) txdps (DOT) state.tx.us> writes
Nothing in SQL Server 2000 requires the framework, and especially not
the Exec Process Task. It does however seem probable that the EXE you
have may well be written in managed code, and it is this that requires
the framework to be installed. I would check with the client, and ask
which version of the framework as well.

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

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

Just found out that the customer's executable needs .NET and not the DTS. Amazing what can happen when you just double click a file. Sorry for the lame post. I went ahead and used an ActiveX Script to execute the file. Here is the code I used in case anyone is looking.

Sub ExecuteTCPS2TOL
Set WshShell = CreateObject("WScript.Shell")
WshShell.Run ("d:\ftp\tcps\tcps2tol.exe")
End Sub

I know it is in a different object model but I am just trying to hack this out as best I can. Gotta go load up .NET on the production SQL box now. Have fun!

----- Mike Mahon wrote: -----

I am building a DTS that generates a file and the customer wants some special things to happen to the file. They have given me an executable to run against the file. The server has SQL 2000 on it and I tried to create an ActiveX script and execute the exe using shell but that didn't work. So I tried to use an execute process task in the DTS but it gave me an error saying it was looking for mscoree.dll. I downloaded and copied mscoree.dll into the system directory now it gives me an error looking for the .NET install root. Is .NET required to run the execute process task for SQL 2000? What is a smart way to do this?

Thanks in advance,
Mike Mahon
SQL DTS Lamer

No the .Net framework is not required for the Execute Process task. What
you execute insiude of the Execute Process task however may require the
framework

mscoree.dll is part of the .Net framework which tells me the exe you are
calling is a .Net exe

http://www.liutilities.com/products/...brary/mscoree/



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Mike Mahon" <mike.mahon (AT) txdps (DOT) state.tx.us> wrote

run against the file. The server has SQL 2000 on it and I tried to create
an ActiveX script and execute the exe using shell but that didn't work. So
I tried to use an execute process task in the DTS but it gave me an error
saying it was looking for mscoree.dll. I downloaded and copied mscoree.dll
into the system directory now it gives me an error looking for the .NET
install root. Is .NET required to run the execute process task for SQL
2000? What is a smart way to do this?