InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 01:10:43 GMT20http://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspx[quote]Yes wzunzip is installed in the system[/quote]Just though I should ask.. Is wzunzip installed on your system or the server you are trying to have run your process?Tue, 07 May 2013 11:24:30 GMTmmartin1http://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxWhat changed? Your last post said error code 9, but this post says exit code 1. Looks like you're calling a different exe now.What mainframe? Is that just a job scheduler remotely executing a job on a Windows machine? Try logging in as the account the mainframe uses and run the job that way. If there is a problem with permissions that's the simplest way to find it.Mon, 25 Feb 2013 09:13:19 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxHi ,Yes wzunzip is installed in the systemError Description: In Executing "C:\Program Files (x86)\WinZip\WINZIP32.EXE" " -e -o *.dat.gz" at "D:\Test", The process exit code was "1" while the expected was "0".Actually when it is run manually it is running when it is run through mainfram job it s throwing this error it is not extracting, can you pls help on this.Or anyone has a script task to unzip this file? Pls let me know asapThanks,SwethaMon, 25 Feb 2013 02:59:08 GMTswetha.prachihttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxiirc exit code 9 means "can't find file" or something like that. Do you have [i]wzunzip[/i] installed at the location shown in the example and are the data files you're referencing in the command line exist?[size="1"]edit: spelling[/size]Wed, 13 Feb 2013 05:43:13 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxIt is throwing error [Execute Process Task] Error: In Executing "cmd.exe" "/c wzunzip -o "" """ at "C:\Program Files (x86)\WinZip", The process exit code was "9" while the expected was "0".Can you pls help me?Tue, 12 Feb 2013 23:35:46 GMTswetha.prachihttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxCan you tell what command need to be given?Tue, 12 Feb 2013 23:34:15 GMTswetha.prachihttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxThat's how I do it - see attachmentMackTue, 12 Feb 2013 07:38:39 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxHow about using the [b]Execute Process Task[/b] to trigger the exe to unzip the file?Tue, 12 Feb 2013 07:28:43 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1418958-147-1.aspxHi,I have a WinZip file with the .dat.gz extension and i need to unzip that zip file and extract the files from it.Can anyone help me out how to do this in ssis 2008?ThanksTue, 12 Feb 2013 07:23:55 GMTswetha.prachi