Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Unzipping files using SSIS

Author  Topic 

jfrench
Starting Member

2 Posts

Posted - 2014-09-25 : 13:28:48
I am new to ssis and I am trying to use a process task to unzip a file.

I am getting the following error



[Execute Process Task] Error:
In Executing "C:\Windows\System32\compact.exe" "/U F:\Imports\RenLearn\Roseville City School District.zip -oF:\Imports\RenLearn\Roseville City School District" at "", The process exit code was "1" while the expected was "0".

My guess I am not defining my variable correctly. Any suggestions.

jfrench
Starting Member

2 Posts

Posted - 2014-09-25 : 14:53:54
I have installed 7z on my sql box and looking to unzip the files. I have followed a few of samples online for using a process task and I am now getting the following error. There are two zip files in the directory and they both are going to the same destination. Any suggestions? Thanks in advance

[Execute Process Task] Error: In Executing "C:\Program Files\7-Zip\7z.exe" "e F:\Imports\RenLearn.zip -oF:\Imports\RenLearn\RenImports" at "", The process exit code was "2" while the expected was "0".

Go to Top of Page
   

- Advertisement -