How do I use WinZip in my DTS package

• Alvin Ramard

  SSC-Forever

  Points: 41190

  More actions

  August 21, 2008 at 3:25 pm

  #861564

  You're welcome.

  I hope they can help you resolve this one.

  ---

  
  Alvin Ramard
  Memphis PASS Chapter[/url]

  All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

  For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  August 21, 2008 at 4:27 pm

  #861590

  You can use the following code:

  declare @Command as varchar(5000)

  set @Command = 'C:\Progra~1\winzip\wzzip.exe "H:\SQLBKUP\test.zip" "H:\SQLBKUP\test.txt"'

  exec master.dbo.xp_cmdshell @Command

  Make sure that 'C:\Progra~1\winzip\wzzip.exe "H:\SQLBKUP\test.zip" "H:\SQLBKUP\test.txt"' is a single long statement in one line(no line change).

  Command line tool that is being talked about can be downloaded from

  http://www.winzip.com/downcl.htm

  HTH

  MJ