Does anyone know how to properly export data to an Excel spreadsheet. I have created a DTS package that correcly exports to an Excel file UNLESS the filename already exists. It then stops on me if the file exists. I delete the file and the DTS runs correctly

Any help would be much appreciated

Thank you
Terri Krin

And what does the package look like ?
How many tasks do you have?
What is in those tasks?
How did you create the task ?

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Terri Kring" <TKring (AT) ololrmc (DOT) com> wrote

filename already exists. It then stops on me if the file exists. I delete
the file and the DTS runs correctly.

In article <D36F7267-7346-4904-B308-4B9990D33476 (AT) microsoft (DOT) com>, Terri
Kring <TKring (AT) ololrmc (DOT) com> writes
What is the full error? What step/task raises the error?


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I am assuming that you created the DTS package using the DTS Designer.

If this is the case, you can recreate your package using the DTS Export
Wizard there is an option to delete the destination table. You get to this
by clicking the elipse on the Select Source Tables and Views dialog box.

Rand
This posting is provided "as is" with no warranties and confers no rights.