SQL 2000 DTS

• Dimitra Ziaka

  Newbie

  Points: 7

  More actions

  January 22, 2008 at 9:01 am

  #178411

  Hello,

  I created a DTS which reads data from an SQL server and writes results in a destination .xls file. Every time this DTS runs , appends a new record into the destination file. How can it ovewrite the destination file?

  Thanks .

• Loner

  SSC-Insane

  Points: 21279

  More actions

  January 22, 2008 at 10:32 am

  #770555

  You may want to create an ActiveX script to clear the xls worksheet or delete the old one and create a new one.