Hi,

I have a DTS package that runs and executable after a table copy has
finished, the executable opens some spreadsheets and executes macros in them
that refresh querytables that rely on the table. I have created the DTS
package and it executes fine. However, when i schedule it the package gets
Access Denied when accessing the spreadsheets.

The SQLAgent is configured to run as a specified account and if i log onto
the server using this account and run the DTS package it executes fine.

Can anyone see where i might be going wrong, thanks for any help.

Steve Lloyd

Is the owner of the job a sysadmin, if not it uses the proxy account as
opposed to the service account you tested.

At what stage is the error?


--
Darren Green
http://www.sqldts.com


"Steve Lloyd" <RemoveSteveThis (AT) laxeyRemovepartners (DOT) com> wrote