SQL Server Performance Forum – Threads Archive

DTS Permission

We just installed Service Pack 3.
Now our DTS won’t work. The first task that executes is an ActiveX script that copies files from one server to another.
It give the error: "File does not exist" It will work in design view (If I click the play button)
But it does not work when the job is scheduled.
Are there permission issues that I may be over looking?
Can I set the executing user?? Thanks,
Brian Linden

---

Its not problem with SP3, its the account used to run the job. Make sure the SQLAgent has got admin privileges on both the machines to copy the file, being its scheduled and controlled by SQLAgent via job scheduler. Refer to books online for DTS permissions topic. HTH Satya SKJ

---

]]>