zip file

[tan873]

how to zip file with xp_cmdshell in sql server 2005

[Simon_Whale]

you can't personally I would use a cmd file that runs a winzip commandline application Winzip[^]

As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

[jschell]

Simon_Whale wrote:

you can't

Why not? If it runs an excutable, per your suggestion, then why would it not run what is already in windows?

[jschell]

tan873 wrote:

how to zip file with xp_cmdshell in sql server 2005

I suppose that depends on exactly what you mean. First step how would you do it in a command shell? Windows has the 'compact' command built in. Comand line options are documented in the help for that as well as at the following. http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/compact.mspx?mfr=true[^] If you want to use something besides 'compact' then you must explore the command line options for that tool. Once you know how to do it from a regular shell then you explore the options with the shell in sql server.