We are tring to use a proxy account to execute jobs
containing DTS packages which are owned by non-sysadmin
accounts (developers).
The package will run standalone, but when placed in the
job, it will fail with an error which indicates the
directory name is invalid:
DTSRun: Loading...
Error: -2147024629 (8007010B); Provider Error: 0 (0)
Error string: The directory name is invalid.
Error source: Microsoft Data Transformation Services
(DTS) Package
Help file: sqldts80.hlp
Help context: 713

If I run the job with dba ownership, the directory and
file are found and the table is loaded.

Any thoughts would be much appreciated!

Kathy

Let me also add that the proxy does have access to the
directory on the server.
tx

How are you specifying the directory?
Have you logged in as the proxy account and tried?
Use UNC paths

What SP level are you running?

People have seen this when the Volume label is the same as the share
name/folder name

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Kathy" <anonymous (AT) discussions (DOT) microsoft.com> wrote