Hi

I have a DTS Package that transforms Data from My SQL Table to a csv
flat file. The problem i am having is that i have to copy this data over
the internet. When extracting the data to the csv file the file size is
176mb after manually compressing(zip) the file I compress it to about
16mb. Is is possible to automatically compress the file once it has been
generated instead of me having to manually compress the file as this
would be a scheduled package.

Any suggessions?

Many Thanks In Advance.

AQ Mahomed


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You could use the command line version Winzip and
the command wzzip to zip the file. You can use an Execute
Process task for this.
You can download the command line add-in from:
http://www.winzip.com/wzcline.htm

-Sue

On Tue, 05 Oct 2004 03:52:41 -0700, AQ Mahomed
<aq786 (AT) shoecrazy (DOT) co.za> wrote:

There is PowerZip and GZIP as well.

"Sue Hoegemeier" <Sue_H (AT) nomail (DOT) please> wrote