DTS Package not running as Scheduled

[qsac]

i have a DTS package that writes to a share.

It works wheni run the package, and when i manually run the job. But it fails when it is scheduled.

THe SQLagent runs as a Domain User that is a local admin on server writing to.

ANy ideas?

 

[SQLBill]

When you manually run the job, it is running as you and not as the 'job owner'. Go to the job and on the General tab, make sure the owner is a login that has permission to access the file. If it's a domain account, it must include the domain. (domain\login)

-SQLBill

Posting advice: FAQ481-4875