Use a batch file, then set up the batch file to run as a Scheduled Task.
The batch file needs to execute “dtsrun” in order to kick off the DTS package from a command line. The essential syntax is as follows:
dtsrun /Syoursqlservername /Usqlserveruserid /Puseridspassword /E /N”The Name Of Your DTS Package On Your SQL Server”
Then set PKZip Self-Extrating version to run against whatever your returned results are, as well as any additional commands you need to do. I, personally, have a Perl script to do the DTS package, zip the results, and email the archive out to the distribution list via SMTP.
There is one caveat: The Scheduled Task needs to run as an authenticated Windows userID, with that userID’s password; so if you change the password to that account, your Task will fail.
Yes, this is from experience. 🙂