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)

Small donation is appreciated

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


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/

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