1. Drag an Exceute Process Task onto your control flow
2. Double click to set the parameters
3. In the process Tab, enter the path to the Winzip32.exe (which tends to be C:\Program Files\WinZip\WINZIP32.EXE although you can use expressions to set this using the config file if you need to consider that it may be installed in different locations on different servers)
4. Select the arguments you wish to pass to the exe using the arguments field, or via expressions if you wish to use variables or a dynamic filename. You can also set the working directory & other required options here - although they are not necessary.
A good article that lists the available command line options for calling Winzip can be found here:
http://www.memecode.com/do
- Winzip.JPG
- 57 KB
Winzip
by: teebonPosted on 2009-10-29 at 00:36:40ID: 25691277
Hi TheCommunicator,
Guys at Codeplex did a great component which just fit your needs:
http://taskunzip.codeplex.
Just download the installer and follow the instructions.
If you are using MSSQL 2005, the installer should work without need to change anything.
However, if you are using other version of MSSQL, for example in my case MSSQL 2008, you need to
1. download the source project, change the reference of these two assemblies:
Microsoft.SqlServer.Dts.De
Microsoft.SQLServer.Manage
2. Edit Install.cmd and change your SQL installation folder accordingly, for MSSQL 2008:
CHANGE
%ProgramFiles%\Microsoft SQL Server\90\DTS\Tasks\
TO
%ProgramFiles%\Microsoft SQL Server\100\DTS\Tasks\
3. Build your project by following the installation steps. Using the msi setup file is the easiest in this case.
4. Open Visual Studio -> Tools -> Choose ToolBox Item -> SSIS Control Flow Items -> Check "TaskUnZip"
5. You can now drag the TaskUnZip task item into your Integration Service Project!