Is Calling A DTS apckage from ASP.NET similar to calling DTS apckage from your workstation using EM - 07-18-2005 , 11:11 AM
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?
Re: Is Calling A DTS apckage from ASP.NET similar to calling DTS apckage from your workstation using EM - 07-18-2005 , 02:53 PM
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:
set osrv = createobject("SQLDMO.SQLServer")
osrv.Connect "db-server", "sa", "topsecretpassword"
set ojobsrv = osrv.JobServer
for each job in ojobsrv.jobs
if job.name = "New Package" then
just a suggestion, there are certainly other means.. (xp_cmdshell and
"J-T" <JT (AT) nospam (DOT) com> wrote