Re: dts vs. job
From: Russell Fields (RussellFields_at_NoMailPlease.Com)
Date: 03/09/04
- Next message: Stefan [MSFT]: "Re: Backup error on Microsoft CMS 2002 SP1A Database"
- Previous message: Dragan Babovic: "RE: Isolate xp_sendmail Errors"
- In reply to: jj: "dts vs. job"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 9 Mar 2004 13:31:16 -0500
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/default.asp?url=/library/en-us/tsqlref/ts_
xp_aa-sz_8sdm.asp
SQL Server Agent Permissions Checks
http://msdn.microsoft.com/library/default.asp?url=/library/en-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?
>
>
- Next message: Stefan [MSFT]: "Re: Backup error on Microsoft CMS 2002 SP1A Database"
- Previous message: Dragan Babovic: "RE: Isolate xp_sendmail Errors"
- In reply to: jj: "dts vs. job"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
