Calling DTS packages from .Net -- sql server dts

Sue Hoegemeier
4/7/2004 5:54:04 AM

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@msn.com>
[quoted text, click to view]

marc
4/7/2004 11:28:20 AM

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

DTJ
4/7/2004 10:29:17 PM

[quoted text, click to view]

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

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Calling DTS packages from .Net