I have a bunch of DTS packages, they run fine when I run
them manually but when I run them scheduled via the SQL
Server Agent they fail. The errors I am getting say they
can't find the source file. I'm sure this is a permissions
problem - but being new with DTS and not having any
knowledge of the network I am working on, I'm at a loss to
figure out how to fix this. I am using SQL Server 2000.
The job owner is a SQL login - ie "sa" or "myLoginName". I
am starting the SQL Server Agent with the "system"
account. Any help would be appreciated! Thanks

If you are using the local system account for SQL Agent then
the jobs don't have access to any network resources. You
would need to use a domain account with appropriate
permissions for the SQL Server Agent service startup
account.

-Sue

On Tue, 19 Aug 2003 13:53:40 -0700, "Julie"
<julie.rodgers (AT) mapinfo (DOT) com> wrote:

If you are attempting to import data from a file on another machine, or
connect to another machine you will need to run the service under a domain
account, and that account will need to be granted access to the needed
files.

--
Denny Cherry
DBA
GameSpy Industries
"Julie" <julie.rodgers (AT) mapinfo (DOT) com> wrote

I will try your suggestions!

Hi Julie,

Please feel free to let us know if you solve this issue or if you need
further assistance.

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Everyone's suggestions helped me solve my problem on one
server. Basically, I made sure the same user was starting
SQL Server and the SQL Agent. The user was a network user
with access to all the servers required (as well as being
a SQL Server user).

I still have a problem accessing an Access database. I now
believe it is a different problem, so will post another
question.

Again- Thanks Everyone for thier help!