SQL Server 2000 DTS packages design

pts.
Tags:
DataCenter
How can build and execute PKZip a text file in a dts package? I would like schedule the dts package, on a weekly basis, to do the following steps: 1) locate the text file in the source folder. 2) zip the text file. 3) transfer the zipped file to the destination folder. 4) notify me that the process is complete.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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. :)

Cheers

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following