November 4th, 2004, 11:17 AM
|
|
Contributing User
|
|
Join Date: May 2004
Posts: 58
Time spent in forums: 13 h 31 m 26 sec
Reputation Power: 5
|
|
|
MS SQL Server - DTS package - how to overwrite files
Hey, all.
I'm running a DTS package on a nightly basis. The DTS package is to export data from a table onto an Excel file.
It works great, but the file seems to append incoming data based on that nightly task. How can I get either the DTS package or the Excel file to be overwritten as opposed to appended?
Thanks in advance!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
