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 2005 Forums
 SSIS and Import/Export (2005)
 Unrar using SSIS package

Author  Topic 

tpavan7329
Starting Member

18 Posts

Posted - 2011-05-18 : 23:26:33
I have an FTP task in SSIS which downloads the .rar file from the FTP to Local Folder(C:\Pavan). I'm trying to find a way to unrar the file in the same location.

I tried to use Execute Process Task in SSIS using following in the process tab

Executable: C:\Program Files\WinRAR\Rar.exe
Arguments: C:\Pavan\*.rar -d C:\pavanWorking Directory: C:\Pavan

I get following error message:

Error:
[Execute Process Task] Error: In Executing "C:\Program Files\WinRAR\WinRAR.exe" "C:\Pavan\*.rar -d C:\pavan\" at "C:\Pavan", The process exit code was "1" while the expected was "0".

I tried looking into forums but i couldn't find a solution. Can anyone help with this?

Note: I'm not trying to download any software to do this task.

Thanks,
Pavan

latch
Yak Posting Veteran

62 Posts

Posted - 2011-05-20 : 10:44:17
Try these:

Process:

RequiredFullfilename True
Executable C:\Programs Files\WinRAR\WinRAR.exe
Argumenys: e H:\Data\SSIS\Test1.rar -o+
Working Directory: H:\Data\SSIs\Output


In the Execute Process, you need to perform three configurations:




Executable: This is the path of the application you are going to use. This specific example has used Winrar.
Arguments: In this you need to supply the arguments to extract the zipped files. In the particular example e stands for Extract files to current directory. Then the full path name of the zipped file. –o+ is a parameter to say overwrite files if they exist.
Working Directory: This is the current directory for the process. In the given example test1.rar will be extracted to the directory given in the Working Directory attribute.

Source:

http://www.sql-server-performance.com/faq/ssis_unzip_p1.aspx

or use:

Chilkat Component to unzip:
http://www.chilkatsoft.com/


Go to Top of Page

tpavan7329
Starting Member

18 Posts

Posted - 2011-05-21 : 22:10:03
Thanks it worked

T Pavan Kumar
Go to Top of Page
   

- Advertisement -