Overview
The Zip Task is an SSIS Control Flow task for compression and decompression of Zip, GZip, BZip2, Unix (rfc1950) and Tar archives.
Demonstration
Parameters
General
Use the General page of the Zip Task Editor dialog to configure the parameters needed for archive compression and decompression.
Specify the task name.
Specify the task description.
Specify the task action. This parameter has the options listed in the following table.
Option Automation Description Compress 1 Compress files into an archive.
IsSourceVariable, Source, SourceVariable specify input files.
Starting from 1.3 SR-3 you can enter multiple source specifications, each one separated with a vertical bar (|).IsTargetVariable, Target, TargetVariable specify the output archive destination.
Decompress 0 Decompress files from an archive.
IsSourceVariable, Source, SourceVariable specify the input archive file.
IsTargetVariable, Target, TargetVariable specify the output files destination.
Specify the type of compression or decompression. This parameter has the options listed in the following table.
Option Automation Description Zip 0 Type of archive is Zip. Tar 1 Type of archive is Tar. File 2 Type of archive is a single file 1.3. When the Zip compression type is selected, this parameter specifies the level of compression - Maximum (4), Maximum (3), Maximum (2), Maximum (1), Maximum (enhanced deflate), Maximum (portable), Normal, Fast, Super fast, None.
When the Tar or File compression type is selected, this parameter specifies the type of compressor used - GZip, BZip2, Unix, None.
Visible only when the specified action is Compress.Specify the archive encryption password. Remember to specify the EncryptionType you want to use.
Visible only when the specified compression type is Zip.Specify the ZIP encryption type. You must also specify a Password in order for the task to perform the encryption. This parameter has the options listed in the following table.
Option Description Zip2 Use regular ZIP 2.0 encryption. AES128 Use strong AES encryption with a 128-bit key. AES256 Use stronger AES encryption with a 256-bit key. Indicate whether or not the source is stored in a variable. This parameter has the options listed in the following table.
Option Description True The source is stored in a variable. Selecting this option displays the dynamic parameter SourceVariable. False The source is specified in a File connection manager. Selecting this option displays the dynamic parameter Source. Select an existing File connection manager, or you may click <New connection...> to create a new connection manager.
Related topics: File Connection Manager
Select an existing user-defined variable, or you may click <New variable...> to create a new variable.
Related Topics: Integration Services Variables, Add Variable
Specify this parameter if you want the task to remove the source files after compression is complete.
Visible only when the specified action is Compress.Specify this parameter if you want the task to recursively include all sub-files and sub-folders.
Visible only when the specified action is Compress and CompressionType is Zip or Tar.Indicate whether or not the target is stored in a variable. This parameter has the options listed in the following table.
Option Description True The target is stored in a variable. Selecting this option displays the dynamic parameter TargetVariable. False The target is specified in a File connection manager. Selecting this option displays the dynamic parameter Target. Select an existing File connection manager, or you may click <New connection...> to create a new connection manager.
Related topics: File Connection Manager
Select an existing user-defined variable, or you may click <New variable...> to create a new variable.
Related Topics: Integration Services Variables, Add Variable
Specify this parameter if you want the task to overwrite the existing target files.
Visible only when the specified action is Decompress.Specify this parameter if you want the task to extract the files in the path stored in the source package.
Visible only when the specified action is Decompress and CompressionType is Zip or Tar.
Knowledge Base
- Where can I find the documentation for the Zip Task?
- Error Message: "Zip Task: Invalid source"
- Error Message: Zip Task: "Length is zero Parameter name: seed"
- How to append files to existing archive
- Does COZYROC's Zip Task support the 7z compression format?
Samples
What's New
- Fixed: Failed with error 'Index was outside the bounds of the array' when trying to decompress Zip package (Thank you, Anders).
- Fixed: Compression of files greater than 8GB using the TAR format created a corrupted package (Thank you, Sri).
- New: Support for Deflate64 algorithm in decompression.
- Fixed: Failed with error "Cannot be less than zero Parameter name: value" when decompressing Tar package containing file larger than 8gb (Thank you, Linson).
- Fixed: Zip decompression failed with error "Wrong Local header signature" when processing certain large files (Thank you, Eric).
- Fixed: Zip decompression failed with error "End of extra data" when processing certain files created with ComponentOne library (Thank you, Anders).
- Fixed: BZip2 file compression failed with error 'Cannot access a closed File.' (Thank you, Krish).
- Fixed: Zip decompression failed with error "CRC mismatch" when processing certain files created with ComponentOne library (Thank you, Anders).
- Fixed: Failed with error "Hash not valid for use in specified state." when decompressing certain AES-encrypted packages (Thank you, Jim).
- Fixed: Task created incorrect entries when compressing files into Tar package and the Source parameter was UNC absolute path (Thank you, Mark).
- Fixed: Created packages with AES encryption which failed to decrypt with newer versions of WinZip and 7-Zip (Thank you, Barry).
- Fixed: Failed with error "Cannot access a closed file" when trying to create Tar archive without compression (Thank you, David).
- Fixed: Failed with error "CRC mismatch" when processing certain packages containing stored-only files (Thank you, Eric).
- Fixed: Task now fails if specified source selection doesn't contain any files (Thank you, Elena).
- Fixed: Failed to extract from Tar package containing files larger than 8gb (Thank you, Bob).
- Fixed: Task created invalid packages when compressing empty files (Thank you, Cameron).
- New: Support for encrypt and decrypt of AES encrypted files.
- New: Task now sets the target file modified date to match the source file, when CompressionType is File (Thank you, Peter).
- Fixed: Failed with "Could not find a part of the path..." error when trying to decompress Tar archives containing folders.
- Fixed: Task included the full path of specified input files when using Tar packages.
- Fixed: When RemoveSource parameter was set:
- Source specified with file pattern was not removed.
- If folder name was specified as a source, the complete folder was removed recursively even when IncludeSubfolders parameter was not set.
- Fixed: Failed to decompress zip files greater than 2gb.
- Fixed: Task will now strip off drive letter from compressed file name, when creating Tar archives.
- Fixed: Failed with error "Cannot access a closed file" when decompressing File.
- New: Included support for extraction from multi-volume Zip archive.
- Fixed: Failed to process correctly wildcard specified source.
- New: Included more validation for source and target package variables.
- Fixed: Task incorrectly created target file when decompressing from Zip or Tar archives.
- New: Included support for processing multiple source wildcard file specifications. Each specification is separated with vertical bar (|).
- Fixed: RemoveSource parameter didn't work properly when compressing single file.
- New: Improved validation of Target parameter when selected action is Decompress.
- New: Introduced task.
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.