SQL Server Developer Center > SQL Server Forums > SQL Server Integration Services > Execute Process Task: 7Zip does not work in Productive Environment
Ask a questionAsk a question
 

AnswerExecute Process Task: 7Zip does not work in Productive Environment

  • Wednesday, November 04, 2009 3:02 PMLutz MTS Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Dear Sirs and Madams,
    question concerning SSIS and 7zip: I need to zip various csv files that are on a server \\X , that different to development and production server. On this data server, files need to be compressed and then deleted. I use 7zip for compressing. 7zip Portable is on the data server \\X. From developement environment everything works out fine, but on production environment fails 7 zip , even though the rest of the task (del *.csv) is beeing done.  The process task looks like this:

    "set remote_path=\\X
    NET USE S: %remote_path%
    S:\test.zip S:\*.csv
    del S:\*.csv
    NET USE /DELETE /Yes S: "

    Help is apreciated, have been spending some time looking on the Internet...





Answers

  • Wednesday, November 04, 2009 11:12 PMGrace VV Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    I'm using a "Execute Process Task" for 7zip.
    In Process: RequiredFullFieldName: True
                     Executable: c:\Program Files(X86)\7-Zip\7z.exe
                     Arguments: e filename.zip -aoa
                     Workdirectory: \\networkdirectory for the .zip file

    It works fine.

    Hope it helps!

    G
     

All Replies

  • Wednesday, November 04, 2009 4:29 PMSudeep Raj Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Could you provide the error message. Havent worked with the 7zip component but lets see if the error message tells something.
    Hope this helps !!
    Sudeep   |    My Blog
  • Wednesday, November 04, 2009 11:12 PMGrace VV Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    I'm using a "Execute Process Task" for 7zip.
    In Process: RequiredFullFieldName: True
                     Executable: c:\Program Files(X86)\7-Zip\7z.exe
                     Arguments: e filename.zip -aoa
                     Workdirectory: \\networkdirectory for the .zip file

    It works fine.

    Hope it helps!

    G