I am attempting to setup scheduled tasks of DTS packages
(on SQL 2000) for non admin users. The packages we are
trying to implement use an ODBC connection from a legacy
system to load an Excel file. The user can successfully
create the package and execute it in design mode.
However, when the user creates a SQL scheduled task for
the package it fails. I have the SQL proxy account for
non-sa users set up as a domain account. The proxy
account has also been added to the local administrators
group on the SQL Server box. I have experienced the
following errors 2147467259, 2147217865, 2147217911,
2147213206. Basically I am at the point of the following
error: Error: -2147217911 (80040E09); Provider
Error: -118490897 (F8EFF8EF) Error string: Cannot
update. Database or object is read-only. Error
source: Microsoft JET Database Engine .

Please note that if the SQL scheduled job is set to sa
ownership, then it runs fine without error. I have been
all through the OLE DB settings for the EXCEL connection,
and have verified that the read only property is set to
false (0).

Any assistance would be greatly appreciated.

In message <73b701c40207$84734530$a101280a (AT) phx (DOT) gbl>, Robert Ross
<bross (AT) keybenefit (DOT) com> writes
Does the proxy account have write permissions to the excel file/folder?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Darren,

Thanks for the input. I had checked both the NT permissions, and the
share permissions earlier, but decided to explicitly give the proxy
account permissions on the destination where we wanted to write the
spreadsheet. Now the job works as a non-sa user, which is what we
wanted.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!