DTS SQL to Excel(overwriting existing file)

[Paulw88]

SQL2000

I am trying to set up a DTS package to download data in an Excel format for analysis on a daily basis. I want it to overwrite the existing Excel file. How can I set this up? Is this set up in the query code and if so, how can I do this via designer? I am not well versed in SQL coding. Any advice or instruction will be appreciated. TIA

Paul

 

[suddenelfilio]

no you can't say overwrite, but you can add an execute process task that you give the dos command to delete the file. This way the new file will be created at the transformation