Post reply

7 zip to decompress a .gz file using command line in ssis

  • May 8, 2009 at 2:07 pm

    #384546

    Hi,

    I have a command line Script that is used to decompress a .GZ file using 7 - zip software.

    I want to use a ssis task to do the same job.

    I can any one guide me to configure the execute process task in ssis.

    the command line that works for me is :

    "C:\Program Files\7-Zip>7z e D:\example.txt.gz -oD:\ *.txt -r "

    this works fine in command line .

    your help is greatly appreciated

    thanks

    Kanthi

  • July 19, 2017 at 12:05 am

    #1951530

    Hi ,
    I need to perform the uncompressing of .xml.gz file with in BODS tool using script.

    print(exec('cmd.exe','C:\Program Files\7-Zip | 7z e F:\B_Target\B\EXTRACT\TEST.xml.gz -oF:\BODS_Target\BCI\EXTRACT\' ,8) );

    Need help to resolve this.🙁

    Note:
    I have used some sample file placing it in my D drive and I tried to uncompressing it  using this command in command prompt
    C:\Program Files\7-Zip>7z e D:\TEST.xml.gz -oD:\    
    its working fine.

  • July 26, 2017 at 12:33 pm

    #1952880

    Here is what I do, use a Execute Process Task

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply