I have a web application that uses server.createobject("DTS.Package")
to access a DTS Package on a different box.

My question is, does the actual CPU processing occur on the web server
where server.createobject("DTS.Package") is invoked, or does the CPU
processing occur on the sql box where the DTS Package resides.

Thanks,
-Ray
raykwatts (AT) gmail (DOT) com

DTS is a client side application so everything occurs on the Box that says
"go"

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Ray" <raykwatts (AT) gmail (DOT) com> wrote

Alan,

Since this object is created on the web server, and the execute command
is issued on the web server, are you saying that the DTS runs on the web
server even though the DTS package itself is on a different box?

Thank you so much,
-Ray Watts



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!