Finn,

Is this possible to use windows task scheduler or SQL job?

Ilya
"Finn" <Finn (AT) discussions (DOT) microsoft.com> wrote

and the dtsrun.exe. This is necessary because we have a number of end of day
procedures which run on the remote machine, and at a specific time within
the end of day run we need to call the execution of the Package. The Package
uses DSNs and when I try to run the batch file it looks for the DSN on the
remote server and not on the SQL Server box. It is as if the DTS job is
being executed on the remote server where the package is being called. Is
this what happens? And if so is there eny way to specify the DTS to run on
the server hosting the Package as opposed to the server calling it?