Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Overwriting an SQL package

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-17 : 22:19:02
Matt writes "SQL Server 7.0 on Windows NT 4.0


I have made a DTS package in the DTS designer. The package was made getting data from SQL and putting it into an Excel spreadsheet.
This package is going to be updated every month and called up in an asp page for users to download.
What i want to know is how to schedule the DTS to overwrite the package every time it is updated instead of just adding onto it which it does now.
If there is a way then please let me know, i'd really appreciate it."
   

- Advertisement -