Re: Export to Excel - File not created
- From: "Arnie Rowland" <arnie@xxxxxxxx>
- Date: Fri, 27 Oct 2006 00:32:36 -0700
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5277C48-30F8-4EBB-A2F8-B2E80EA69360@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: Dynamically Export to Excel.
- Next by Date: RE: Passing Parameters to an Execute SQL Task in SSIS
- Previous by thread: Which one to use : dts / bcp / bulk insert ?
- Next by thread: Re: DTSing to Oracle...
- Index(es):
Relevant Pages
|
