Hi,

I have a dts package which calls a win32 process.
when i call that dts package from a .Net client it tries to run the process
on the client and not on the server

how do I get the process running on the server.

thanks
Marc

One way would be to be to put it in a job and execute the
job. DTS runs from the location where it's executed. If you
execute it from your PC, it runs from your PC and under your
security context. If it's a job, it runs on the server under
the security context of SQL agent if the job is owned by a
sysadmin.

-Sue

On Wed, 7 Apr 2004 11:28:20 +0200, "marc" <heev (AT) msn (DOT) com>
wrote:

On Wed, 7 Apr 2004 11:28:20 +0200, "marc" <heev (AT) msn (DOT) com> wrote:

Use your app to call a stored procedure, which kicks off a scheduled
job.