Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2007-01-10 : 08:40:43
|
| I have set up a couple of DTS local packages to run ActiveX scripts creating XML files and copying them to our webserver (on the same domain).I can run them OK manually via the 'Execute' package command in the drop down list when I right click on them and also get the 'Package successfully run' message back on running them, but when I schedule them to run overnight I find the SQL Server Agent reports them as 'failed' although other packages set up seem to be running OK when scheduled.What am I doing wrong? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-01-10 : 08:53:00
|
| Enable logging on your package (if not already enabled), and check to see what's causing it to fail. I suspect it's a permissions issue. Remember that scheduled packages will execute in the context of the SQL Server Agent service account.Mark |
 |
|
|
|
|
|
DTS package failing on schedule run?