12 people following this project (follow)

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.
  • Support file zip >= 4GB.
  • Support SQL Server 2005 (ver. 1.2.0.0) and SQL Server 2008 / R2 (x86 and x64).


Small donation is appreciated


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 version for SQL Server 2005 (use ver. 1.2.0.0).
  • 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 ..\InstallSQL2008.cmd or ..\InstallSQL2008_x86.cmd (Run as Administrator)
    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 ..\Un-InstallSQL2008.cmd or ..\Un-InstallSQL2008_x86.cmd (Run as Administrator)
    4. Start SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Start)



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)

  • 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 ..\InstallSQL2008.cmd or ..\InstallSQL2005.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 ..\Un-InstallSQL2008.cmd or ..\Un-InstallSQL2005.cmd
    4. Start SQL Server Integration Services (HOW TO: Control Panel>Administrative Tools>Services>right-click SQL Server Integration Services>Start)



Ver. 1.0.0.2
  • This versione support only zip format.
  • This versione support only SQL SERVER 2005.
  • 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

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 Dec 11 2011 at 4:48 PM by goldfix, version 52