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

Features:
  • Support to ZIP, TAR and TAR / GZ archive.
  • Compress single file or entire folders and / or sub folders.
  • Decompress all or singles files.
  • Encrypt with password zip file.
  • Insert Comment to zip file.
  • Verify archive file before extraction and after compression.
  • Support file ZIP >= 4GB.
  • Configure 'Type Store Paths'
  • 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.*)

Small donation is appreciated


Ver. 1.4.6.0 Beta
  • Ver. 1.4.6.0: fixed bug decompress process (tnx Ben: https://taskunzip.codeplex.com/workitem/21274)
  • compatibility with Sql Server 2012
  • add support for TAR and TAR / GZ
  • add parameter "Add root folder"
  • add parameter "Type Store Paths":
    • No_Paths
    • Relative_Paths
    • Absolute_Paths
  • review: parameters and descriptions
  • add more information in 'log result'
  • embedded (and removed) ICSharpCode.SharpZipLib.dll library
  • other minor fix


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)


Tnx to: http://icsharpcode.github.io/SharpZipLib/
Tnx to: Arthur Lindow
Tnx to: Kevin Wendler
Tnx to: JohannesHoppe
Tnx to: joniwho
Tnx to: Ben
Tnx to: cois
Tnx to: wsobolewski

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

Last edited Sep 20 at 1:12 PM by goldfix, version 79