I need to export data daily in Excel format, the file name
changes every day eg Exportddmmyyyy.xls. This works OK if
you run it manaually but when you schedule it a a Job, it
failes every time. I have a item that deletes the tempory
table and rebuilds it, but as the name changes each time
it always fails when deleting the temp table. Any idea how
to solve the problem

The following article on sqldts.com shows you how to change
the file name for a connection:
http://www.sqldts.com/default.aspx?200

-Sue

On Tue, 7 Sep 2004 00:07:37 -0700, "Allan"
<asql (AT) penstonall (DOT) co.uk> wrote: