• Replies 24 replies
  • Subscribers 336 subscribers
  • Views 52 views
  • Users 0 members are here
Related

Zipping a txt file

Former Member
Former Member $organization

Hi

I'm trying to zip a Text file in SQL but once I run the command, sql keeps executing for long time and I don't get any error.

EXEC master..xp_cmdshell 'T:\Source\WinZip\winzip32.exe T:\Source\sso_pacingdata.zip T:\Source\sso_pacingdata.txt'

I also tried,

EXEC master..xp_cmdshell 'T:\source\WinZip\winzip32.exe -o T:\Source\sso_pacingdata.txt'

Probably my syntax is wrong. Can anyone please let me know the right syntax to Zip a Text file.

Thanks

Varsha

Parents
  • Former Member
    Former Member $organization

    But the first  question is – Does this command-line work if you run it from a batch file?

    If it doesn’t, then it’s not a SQL syntax problem, it’s a Winzip syntax problem.

     

    ...and I have a feeling –o is an extraction option code, rather than a compression option code. I’d try –a ( add) as the option code instead.

     

    Ken McSwain Business solutions Manager

    kmcswain@sydneyoperahouse.com

    T+61 2 9250 7876  F+61 2 9251 7821  M 0418 659 360

     

    SYDNEY OPERA HOUSE BENNELONG POINT

    GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

    SYDNEYOPERAHOUSE.COM

     

     

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Reply
  • Former Member
    Former Member $organization

    But the first  question is – Does this command-line work if you run it from a batch file?

    If it doesn’t, then it’s not a SQL syntax problem, it’s a Winzip syntax problem.

     

    ...and I have a feeling –o is an extraction option code, rather than a compression option code. I’d try –a ( add) as the option code instead.

     

    Ken McSwain Business solutions Manager

    kmcswain@sydneyoperahouse.com

    T+61 2 9250 7876  F+61 2 9251 7821  M 0418 659 360

     

    SYDNEY OPERA HOUSE BENNELONG POINT

    GPO BOX 4274, SYDNEY NSW 2001, AUSTRALIA

    SYDNEYOPERAHOUSE.COM

     

     

    Please consider the environment before printing this email.
    =====This message is intended for the addressee(s) named and may contain confidential information.
    If you are not the intended recipient, please delete it and notify the sender.
    Views expressed in this email are those of the individual sender and are not necessarily the views of the Sydney Opera House Trust=====
Children
  • $organization in reply to Former Member

    Hi Varsha,

     

    I agree with Ken, you can test it in cmd windows, and I think you should use option -a not -o too.

    this will work.

    declare @cmd varchar(1000)

    set @cmd='"T:\Source\WinZip\winzip32.exe" -a "T:\Source\sso_pacingdata.zip" "T:\Source\sso_pacingdata.txt"'
    select @cmd
    EXEC master..xp_cmdshell @cmd

     

    have fun

    Ben