TaskUnZip for SSIS

Simple Task for SSIS (SQL Server Integration Services) for manage, compress and decompress file ZIP.

Features:

• Compress single file or entire folders and / or sub folder.
• Decompress all or singles files.
• Encrypt with password zip file.
• Insert Comment to zip file.
• Verify zip file before extraction and after compression (not encrypted).
• Support file zip >= 4GB.
• Support SQL Server 2005 (ver. 1.2.0.0)
• Support SQL Server 2008 / R2 (x86 and x64) (ver. 1.3.0.1)
• Support SQL Server 2012 (ver. 1.4.0.0)

Ver. 1.4.0.0

• add compatibility with Sql Server 2012
• add option overwrite destination file zip
• other minor fix
• update batch file
• Remove Support version for SQL Server 2008 / R2 (use ver. 1.3.0.1).

---

Ver. 1.3.0.1

• Add: Support SQL SERVER 2008 and SQL SERVER 2008 R2.
• Add: installation batch file for x86 e x64 (tnx JohannesHoppe).
• Upgrade sample with foreach loop task.
• Upgrade SharpZipLib for .NET Framework ver. 0.86.
• Upgrade solution to Visual Studio 2010.
• Remove Support version for SQL Server 2005 (use ver. 1.2.0.0).

---

Ver. 1.2.0.0

• Add: Support SQL SERVER 2008 / 2005.
• Add: recursive compress.*
• Add: filter option for extract and compress file.*
• Add: Test archive.
• Add: Comment archive.
• Bug: Correct installation bug.
• Minor corrections.
• Support creation file > 4GB.

*(Tnx to: Kevin Wendler)

---

Sample: The Task Settings

Compression Properties settings:

TypeOperation: Compress
File Destination: ZipFileName.zip
File Source: .*
FolderSource: C:\LocalReports\SSIS\SourceFolder
FolderDestination: C:\LocalReports\SSIS\DestFolder
FileZip: SampleFileZip.zip
RecurseSubFolder: True

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

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