Groups | Blog | Home
all groups > sql server dts > september 2004 >

sql server dts : DTS and Excel


Allan
9/7/2004 12:07:37 AM
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

Sue Hoegemeier
9/7/2004 6:25:23 AM
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"
[quoted text, click to view]
AddThis Social Bookmark Button