I'm using SQL Server 2005. I've built a DTS. Essentially it does this:

Create a table and insert data
Delete an excel file
Export the table to Excel

In BI Dev studio, the package runs just fine and everything works perfectly.

However, when I run it with the SQL Server Agent, the table is created fine,
however the Delete Excel file step and the Export to Excel step don't work.

I thought maybe this was a permissions issue, but I've tried everything I
can think of.

Any ideas of what may be causing this?

Thanks....
--
Jeff

It sounds like an OS level permission issue.

Does the network account that SQL Agent runs under have file create/delete
permissions in the destination folder?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Jeff Reese" <JeffReese (AT) discussions (DOT) microsoft.com> wrote

Thanks for the reply.

Yes, the account SQL Server Agent runs under has full access to the folder.
The agent is running using my account (not the Local System account). My
account has full access to the destination folder.
--
Jeff


"Arnie Rowland" wrote: