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.
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 tabExecutable: C:\Program Files\WinRAR\Rar.exeArguments: C:\Pavan\*.rar -d C:\pavanWorking Directory: C:\PavanI 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 TrueExecutable C:\Programs Files\WinRAR\WinRAR.exeArgumenys: e H:\Data\SSIS\Test1.rar -o+Working Directory: H:\Data\SSIs\OutputIn 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.aspxor use:Chilkat Component to unzip:http://www.chilkatsoft.com/ |
|
|
tpavan7329
Starting Member
18 Posts |
Posted - 2011-05-21 : 22:10:03
|
Thanks it workedT Pavan Kumar |
|
|
|
|
|