Zip Task

Overview

Zip Task is SSIS Control Flow task for compression and decompression of Zip, GZip, BZip2, Unix and Tar archives.

Setup

Use the General page of the Zip Task Editor dialog to configure the options needed for archive compression and decompression.

Options

Name

Specify task name.

Description

Specify task description.

Action

Specify task action. This property has the options listed in the following table.

Value	Description
Compress	Compress files into archive. IsSourceVariable, Source, SourceVariable specify input files. IsTargetVariable, Target, TargetVariable specify output archive destination.
Decompress	Decompress files from archive. IsSourceVariable, Source, SourceVariable specify input archive file. IsTargetVariable, Target, TargetVariable specify output files destination.

CompressionType

Specify type of compression or decompression. This property has the options listed in the following table.

Value	Description
Zip	Type of archive is Zip.
Tar	Type of archive is Tar.

CompressionLevel

Visible only when specified action is Compress.
When Zip compression type is selected, the parameter specifies the level of compression.
When Tar compression type is selected, the parameter specifies type of compressor used - GZip, BZip2, Unix, None.

Password

Visible only when specified compression type is Zip. Specify archive encryption password.

IsSourceVariable

Indicates whether the source is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The source is stored in a variable. Selecting the value displays the dynamic option SourceVariable.
False	The source is specified in a File connection manager. Selecting the value displays the dynamic option Source.

Source

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager

SourceVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

RemoveSource

Visible only when specified action is Compress. Specify if task has to remove source files after compression is done.

IncludeSubfolders

Visible only when specified action is Compress. Specify if task has to recursively include all sub-files and sub-folders.

IsTargetVariable

Indicates whether the target is stored in a variable. This property has the options listed in the following table.

Value	Description
True	The target is stored in a variable. Selecting the value displays the dynamic option TargetVariable.
False	The target is specified in a File connection manager. Selecting the value displays the dynamic option Target.

Target

Select an existing File connection manager, or click <New connection...> to create a connection manager.

Related topics: File Connection Manager

TargetVariable

Select an existing user-defined variable, or click <New variable...> to create a variable.

Related Topics: Integration Services Variables, Add Variable

OverwriteExisting

Visible only when specified action is Decompress. Specify if task has to overwrite existing target files.