Unable to overwrite files using Process Task

• hegdesuchi

  Hall of Fame

  Points: 3047

  More actions

  July 8, 2016 at 11:21 am

  #400382

  Hi Folks,

  I am having problem in overwriting the existing files through Process Task.

  I tried with below steps :

  Step 1:

  Argument: "e "+ "-o+ "+ "C:\Folder\test.zip"

  Executable:"C:\Program Files\7-Zip\7z.exe"

  working directory: the folder where I would want to overwrite the files.(C:\Folder\Project\)

  This would create a folder with "+" in C:\Folder\Project\ and then unzip the files. But I want to overwrite existing files in C:\Folder\Project\.

  Reference: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4908467f-3da9-49cf-be59-2c8ee0824666/how-to-unzip-file-which-zipped-using-winrar-by-using-execute-process-task-in-ssis?forum=sqlintegrationservices%5B/b%5D

  Step 2:

  Argument: "x" +“C:\Folder\test.zip” +" -o+ " + "C:\Folder\Project\"

  Executable:"C:\Program Files\7-Zip\7z.exe"

  This will not unzip the files at all. The process just executes and finishes.

  Reference : https://msbigurukool.wordpress.com/2014/01/11/extracting-a-zip-or-rar-file-using-execute-process-task-in-ssis/%5B/b%5D

  But If I try with "x" +“C:\Folder\test.zip” +" -o " + "C:\Folder\Project\", then the files get unzipped without issues. Next time I try to unzip it asks manually whether we have to overwrite or not. I do not want this and want just to overwrite files without asking.

  Can anyone of you help me in understanding where am I going wrong?

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  July 8, 2016 at 11:49 am

  #1889237

  Maybe you could try using Overwrite Mode when doing the extraction.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• hegdesuchi

  Hall of Fame

  Points: 3047

  More actions

  July 8, 2016 at 12:31 pm

  #1889243

  thank you very much.. it is working for me now with "x"+ "c:\folder" +"-aoa" 🙂