Introduction
This tip will show you how to Rar and UnRar files like Excel, Text Files, XML Files, etc. in SSIS 2008 R2.
Using the Code
Step 1
Create the "ZipUnZipSample" folders in C:\ path. Create the 3 other folders in "ZipUnZipSample" folder. Give the names for folders ExcelFiles, "UnZipFiles" and "ZipFiles". Add excel file (.xlsx) in ExcelFiles folders.
Step 2
Create the project and package in SSIS 2008 R2.
Step 3
Add Execute Process Task in Control Flow tab. Change the name "Rar files". Right click and click on Edit option to open the Editor. Select on the Process tab from left pane. Set the below properties:
- Executable = C:\Program Files\WinRAR\WinRAR.exe
- Arguments =a "C:\ZipUnZipSample\ZipFiles\ZipFiles.rar" "C:\ZipUnZipSample\ExcelFiles\*.xlsx"
- WindowStyle = Hidden
Step 4
Add another Execute Process Task in Control Flow Tab. Change the name "UnRar files". Right click and click on Edit option to open the Editor. Select on the Process tab from left pane. Set the below properties:
- Executable = C:\Program Files\WinRAR\WinRAR.exe
- Arguments = e -o+ "C:\ZipUnZipSample\ZipFiles\ZipFiles.rar" "C:\ZipUnZipSample\UnZipFiles\"
- WindowStyle = Hidden
Step 5
Connect the Rar Files Task to UnRar Files Task with Success constraint.
Step 6
Now run the package to Rar and UnRar files.
Step 7
Check the ZipFiles and UnZipFiles folders.