Hi,

I have exported data from 3 tables to 3 different flat files. I am
sending all the 3 files using xp_sendmail procedure. I need to zip all the 3
files into a single file and
send it off. How can I do this?

Regards,


Sevugan.C

You could use the command line version Winzip and
the command wzzip to zip the files. You can pass a file
containing a file list, use wild cards, or specifiy a file
list:
wzzip c:\NewZip.zip c:\Folder\File1.txt c:\Folder\File2.txt
There are other options in the wzunzip reference help file.
You can download the command line option which will have the
command line help file from:
http://www.winzip.com/wzcline.htm

-Sue

On Wed, 6 Jul 2005 00:33:01 -0700, "Sevugan"
<Sevugan (AT) discussions (DOT) microsoft.com> wrote:

This is how I will do it.
1) Create a dos batch file (.bat) which takes command line parameters
2) call pkzip.exe to zip the files.

hope this helps

"Sevugan" wrote:

Hi,
I am using the command line version of winzip as you said.
When I execute the below said command I able to zip the files.\
If the same command is executed from SQL Server it keeps on running.
How do I resolve this?

--
Sevugan.C


"Sue Hoegemeier" wrote:

Hi
Can you give me a small example?
I need to pass the souce and the destination file sas parameters to the
batch file.
So, It would be better if you give a small example of how to do it.



Thanks and Regards,

Sevugan.C


"str777" wrote: