DTS to Zip | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS to Zip

Has anybody ever created a step in DTS to zip a text file prior to emailing. We have a monthly process that email AR data to Dun & Bradstreet (via text file). The file has gotten too large to email, so I would like to zip it prior to sending. If anyone has any ideas, let me know. Thanks
I think you can handle creating ZIP file using activex script which in turn is using VBscript.
So using VB you can use ZIP.exe utility to zip your files.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=24736 says using the execute process task (although the same thing happens if I try to just use command line). The win32process line is C:program FilesWinZipWZUNZIP.EXE And the Parmaters line is -o "\FilePathFile.zip" "\Filepath"
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at