Simple Task for SSIS (SQL Server Integration Services) for manage compress file ZIP. This task (Control Flow Items), permit compress/decompress file zip in SSIS Task context. Support password, comment, test archive and creation file zip > 4GB.
Work in Progress! ;-)

Small donation is appreciated: Donate


Ver. 1.3.0.1
  • Add: Support SQL SERVER 2008 and SQL SERVER 2008 R2.
  • Add: installation batch file for x86 e x64 environment (tnx JohannesHoppe).
  • Upgrade sample with foreach loop task.
  • 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 3:17 PM by goldfix, version 44