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 |
|
kunaaldesai
Starting Member
36 Posts |
 Posted - 2009-10-31 : 17:45:42
|
| I am using WinRar software to unzip files and I am trying to do this by SSIS.I am using "Execute Process Task" for this and within the process tab I am specifying following specifications.Executable: C:\Program Files\WinRAR\WinRAR.exeArguments: FilenameDESAI_Kunal09.rar] Folder[C:\Users\kunaal\Desktop\Output]where Folder is the option which I think I have to declare to tell "Execute Process Task" that this is where it has to load all the extracted files. I am y be wrong in this. I don't have any reference which I can refer to in order to understand command line arguments properly. You can forward me one.Apart from this, when I run the package then it is successfully running but I do not see any extracted files loaded into the folder "Output", which I have defined in folder option of arguments.There is certainly something which I am doing wrong. Can anybody please guide me in this matter?Anything |
|
|
sportrx
Starting Member
4 Posts |
Posted - 2010-05-20 : 17:19:26
|
| Does WinRar has a commandline exection? I used 7zip it has good command line.Next, in your "exec process task' you need to enter the path to the executable unzip, agurement, and a working folder.Here is an example of what you need to define:Execute Process Editor >> Process >>Executable: \\MyPC\ETL\7-Zip\7z.exeArgumement: "e " + @[User::ZipFileName] --this is a fullqualified name of the zipfile, e is for extract WorkingDirectory: \\MyPC\ETL\Files\TrackingFile |
 |
|
|
|
|
|
Unizpping from SSIS