Hi All,

I have a DTS package which create a folder on drive C using an Activex
Script(simple).When I call this from server and through Enterprise manager
,the folder is created on the server ,when I call it throug on my workstatin
using Enterprise Manager the folder is created *on my computer* (again
simple). Now I have an ASP.NET application on server A and DTS package is
on Server B .If I make a request from my workstation to Server A asp.net
page to call the package on server B,where the folder is created ? Server
A,Server B or my workstation?

Thanks

i'll bet for the web server.
shedule the job, and then use SQLDMO from your asp application to start it,
it will then run under the SQL server agent's account, on the DB server.

vbscript quick and dirty example:
dim osrv
set osrv = createobject("SQLDMO.SQLServer")
osrv.Connect "db-server", "sa", "topsecretpassword"
dim ojobsrv
set ojobsrv = osrv.JobServer
for each job in ojobsrv.jobs
if job.name = "New Package" then
job.start
end if
next

just a suggestion, there are certainly other means.. (xp_cmdshell and
dtsrun.exe, etc..)

"J-T" <JT (AT) nospam (DOT) com> wrote