My DTS extract data from the database and export to an excel file, i want to delete previous data from the excel file and just export new one.
for some resons i dont want to delete excel file and recreate it, neither i want to append the data.
Is it possible through DTS....without creating Linked server with excel file.