I am new to SQL Server.
I have a DTS package that produces a output file call extract.xls . Every time the package runs the output is appended to the extract.xls file. How can design the DTS package that will overwrite or delete the extract.xls file before the output is produced ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!