HI, I am using the Compress.exe to Zip a file...with no password, just zip it. At this time I need to do the reverse, there's a Zip protect file and I need to Unzip with Psw... How can I achieve this on SSIS? For the zip I am using the Execute process Task Editor , calling 'C:\Program Files\Windows Resource Kits\Tools\compress.exe' and adding arguments as -z -r Can you give me an example of using the other way? I can't have Winzip on the Server where am running the packages.. Thanks in advance. Pats.

Hi Pats, Based on my understanding Compress.exe does not unzip. If so, you need a different utility and find out what are the command line parameters. Then to implement you use a similar approach using the Execute Process Task, or you can make it a BAT file that accepts parameters that you can run the same way. One such uncomressing utility I was able to Bing is http://www.camunzip.com/Arthur My Blog

Thanks for your reply, but... of course as you said, "you need a different utility and find out what are the command line parameters. " That's why am asking here... I know compress won't work cause is Compress... not Uncompress.exe... Hope someone had to add something similar to SSIS. Thanks Pats.

Pats, I would recommend you check the commercial CozyRoc Zip Task. It supports both compression and decompression of regular and password protected file. The task is completely integrated in SSIS and easy to use.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Hi Pats, You can use WinRar to unzip the file, please take the configuration of the Execute process task as below: Executable: C:\Program Files\WinRAR\WinRAR.exe Arguments: e filename.zip -o+ For more information about it, please refer to: unzip a file in SQL server Integration services (SSIS) package: http://parasdoshi.com/2011/09/07/ssis-using-sql-server-integration-services-ssis-to-unzip-a-file/ And here is a simliar thread, please take it as reference: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/00f110d9-9be8-481c-9696-75be9973e728 Thanks, Eileen