Zip a file after DTS export

[jhall01]

Is it even possible. I have a DTS job that exports data out to an excel (looking to export to text in the future to reduce data size). Some of these files get upwords of 8-10 MB. I need to zip this in an automated fashion. any idea?

I am going to eventually setup automatic emails to attach the zipped files and send to the recipients, so i need the files zipped.

Thanks,

Jon

 

[jhall01]

My bad, found an exact same thread here:

[URL unfurl="true"]http://www.tek-tips.com/viewthread.cfm?SQID=893204&SPID=961&page=1[/url]