TaskUnZip for SSIS

Simple Task for SSIS (SQL Server Integration Services) for manage compress file ZIP. This task (Control Flow Items), permit compress/decompress file zip in SSIS Task context. Support password.
Work in Progress! ;-)

• This versione support only zip format.
• For Manual Installation:

1. Stop SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Stop)
2. Execute ..\TaskUnZip\TaskUnZip\bin\Debug\Install.cmd
3. Open Visual Studio and Add in "Control Flow Items" TaskUnZip (select TaskUnZip from list)
4. Start SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Start)

• For Manual Un-Installation:

1. Open Visual Studio and Remove from "Control Flow Items" TaskUnZip (de-select TaskUnZip from list)
2. Stop SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Stop)
3. Execute ..\TaskUnZip\TaskUnZip\bin\Debug\Un-Install.cmd
4. Start SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Start)

• MSI Installation:

1. Stop SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Stop)
2. Execute TaskUnZip_Setup.msi
3. Open Visual Studio and Add in "Control Flow Items" TaskUnZip (select TaskUnZip from list)
4. Start SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Start)

• MSI Un-Installation:

1. Open Visual Studio and Remove in "Control Flow Items" TaskUnZip (de-select TaskUnZip from list)
2. Stop SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Stop)
3. Uninstall TaskUnZip_Setup.msi
4. Start SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Start)

Sample: The Task Settings

Decompression Properties settings:

Compress: False
File Destination:
File Source: ZipFileName.zip
Folder Destination: C:\LocalReports\SSIS\
Folder Source: C:\LocalReports\SSIS\

Compression Properties settings:

Compress: True
File Destination: ZipFileName.zip
File Source:
Folder Destination: C:\LocalReports\SSIS\
Folder Source: C:\LocalReports\SSIS\

Tnx to: http://sharpdevelop.net/OpenSource/SharpZipLib/
Tnx to: Arthur Lindow

pietro partescano
http://blogs.ugidotnet.org/sqlog/