How to overwrite DTS package logs everytime the package executes?
You can configure your DTS packages to log the execution status and errors to SQL Server tables or to text files. This is a very useful feature for diagnosing and troubleshooting problems and monitoring execution status of DTS packages (scheduled or otherwise). Unfortunately there is no option exposed by DTS user interfae or object model, to clear these logs. Information always gets appended to the log files or log tables. This results in huge log tables or text files over a period of time (also depends on the package schedule) and makes it difficult to access the information. When the packages are configured to log errors to SQL Server tables, you could configure a job to clear out these tables periodically, or you could add an “Execute SQL” task to your DTS package to clear these log tables. It gets a little trickier if you configure your packages to log errors to a text file. You could clear these log files in several ways and this article shows you one of those. Idea is to use the
