dts vs. job

I have a DTS package that runs fine on a SQL 7 sp3 box. When I try and run
it as a job it fails with this error:
DTSRun: Loading...
Error: -2147287038 (80030002); Provider Error: 0 (0)
Error string: The system cannot find the file specified.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp
Help context: 713
Any ideas?Check out the following article:
269074 INF: How to Run a DTS Package as a Scheduled Job
http://support.microsoft.com/?id=269074
Rand
This posting is provided "as is" with no warranties and confers no rights.|||jj,
The problem is probably the context that DTS is executing under. One thing
to remember is that DTS is a client process, not a server process.
When run interactively, where is it running? If you are running it from your
machine, then access to the package would be obtained using your domain
rights. If you login to the SQL7 box, then the login that you use must have
the proper domain rights to get to the file.
Now, when you run it as a SQL Agent job, it will run either as the SQL
Server service account (e.g. MyDomain/MySQLServer) or if the job is not
owned by a sysadmin it runs as the SQL Agent proxy account (e.g.
MyDomain/MySQLAgentProxy). See:
xp_sql_agent_proxy
http://msdn.microsoft.com/library/d...-us/tsqlref/ts_
xp_aa-sz_8sdm.asp
SQL Server Agent Permissions Checks
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_automate_054p.asp
Which ever account is _actually_ in use must have the necessary rights to
access the package.
Russell Fields
"jj" <jeff_detoro@.urmc.rochester.edu> wrote in message
news:eLsAD$eBEHA.744@.TK2MSFTNGP10.phx.gbl...
> I have a DTS package that runs fine on a SQL 7 sp3 box. When I try and run
> it as a job it fails with this error:
> DTSRun: Loading...
> Error: -2147287038 (80030002); Provider Error: 0 (0)
> Error string: The system cannot find the file specified.
> Error source: Microsoft Data Transformation Services (DTS) Package
> Help file: sqldts.hlp
> Help context: 713
> Any ideas?
>