Scheduled DTS packages

Hi All,
I'm running into a problem executing a dts package. The package completes
fine, however once it gets scheduled it fails. The package references a
script on another server, so I'm assuming the job scheduler is not passing
along my credentials, however I schedule to job to runas me. I've seen the
problem with it would schedule a job that referenced \\machine\c$, but
references shares don't seem to work too.
what am i doing wrong?
Have a look at
INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/default...;en-us;Q269074
This has a section on the various security contexts involved. If you are a
sysadmin then the SQLAgent service account needs to be given access to the
remote server.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"michael" <michael@.discussions.microsoft.com> wrote in message
news:E298049D-0691-4262-8A28-C340806E52A1@.microsoft.com...
> Hi All,
> I'm running into a problem executing a dts package. The package
> completes
> fine, however once it gets scheduled it fails. The package references a
> script on another server, so I'm assuming the job scheduler is not passing
> along my credentials, however I schedule to job to runas me. I've seen
> the
> problem with it would schedule a job that referenced \\machine\c$, but
> references shares don't seem to work too.
> what am i doing wrong?