From my understanding, when a DTS Package is launched remotely the package is
run using the resources of the remote machine. Is there a way to launch a
DTS Package remotely and have it use the resources of the server?

The problem I am having is that the server has email recipients defined in a
different Profile Name then the remote machines. So when I run a package
from the remote machine or process, after having the Profile Name set on the
server, that email task fails.

In message <5677234F-BE5B-4B45-81F0-13C0560A04DF (AT) microsoft (DOT) com>, whornak
<whornak (AT) discussions (DOT) microsoft.com> writes
You need to launch it on the server to get it to execute there. A couple
of methods are to call it via T-SQL (sp_OA* procedures or xp_cmdshell
and dtsrun), or use a SQL Server Agent job and start the job.


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

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