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

  • 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.
  • Support SQL Server 2008 / R2 (x86 and x64) (ver.
  • Support SQL Server 2012 (ver.

Small donation is appreciated

  • Minor fix batch file.
  • Rebuild with Visual Studio 2012

  • 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.

  • 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.

  • 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:
File Source: .*
FolderSource: C:\LocalReports\SSIS\SourceFolder
FolderDestination: C:\LocalReports\SSIS\DestFolder
RecurseSubFolder: True

Tnx to:
Tnx to: Arthur Lindow
Tnx to: Kevin Wendler
Tnx to: JohannesHoppe

pietro partescano

Last edited Mar 14 at 3:29 PM by goldfix, version 63