Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole



Buy Now Free Trial Download Compare Editions More Features

Task Factory Compression Task (Zip or Unzip)

Compresses or decompresses a file or directory. Many companies struggle with transmitting files larger than 1 GB. Our Compression Task will compress files within SSIS by up to 90%, allowing greater speed and less network space.

Feature Highlights

  • Used to compress and decompress files and directories
  • Supports the use of Zip, Bz2, and GZip compression algorithms
  • Supports creating a self-extracting EXE
  • Supports password protected zip files
  • Easy to use User Interface
Compression Task (Zip or Unzip)

SSIS Compression (Zip / Unzip) Task- Step 1
Task Settings

The Compression Task UI is used to control the settings for the Pragmatic Works Compression Task.

The default compression settings for the compression task are:

  • Task Action: Compress
  • Compression Type: Zip
  • Zip Settings
    • Compression Level: None
    • Password: No value is provided
    • Create Self-Extracting EXE: Unchecked

If you would like to change any of the default compression setting you can do that in the Advanced tab


Task Settings

The Compression Task UI is used to control the settings for the Pragmatic Works Compression Task.

The default compression settings for the compression task are:

  • Task Action: Compress
  • Compression Type: Zip
  • Zip Settings
    • Compression Level: None
    • Password: No value is provided
    • Create Self-Extracting EXE: Unchecked

If you would like to change any of the default compression setting you can do that in the Advanced tab


SSIS Compression (Zip / Unzip) Task- Step 2
General Tab


General Tab


SSIS Compression (Zip / Unzip) Task- Step 3

Source Files or Directory

  • Source stored in a variable - Selecting this checkbox will replace the "Source Connection Manager" with "Select source variable" and the drop down will be populated with all of the user created string variables within your package. The task will now expect the variable to contain the file or directory path to be compressed / decompressed. 

Source Files or Directory

  • Source stored in a variable - Selecting this checkbox will replace the "Source Connection Manager" with "Select source variable" and the drop down will be populated with all of the user created string variables within your package. The task will now expect the variable to contain the file or directory path to be compressed / decompressed. 

SSIS Compression (Zip / Unzip) Task- Step 4
  • Source connection manager - Available if "Source stored in a variable" is not selected. 

The source connection manager selected will contain the path to the file or directory (zip compression only) that will be used for compression / decompression.

  • Source connection manager - Available if "Source stored in a variable" is not selected. 

The source connection manager selected will contain the path to the file or directory (zip compression only) that will be used for compression / decompression.

SSIS Compression (Zip / Unzip) Task- Step 5
You can select "Create New FILE Connection...>" or "Create New FLATFILE Connection...>" to create a new connection manager that will contain the path to the source file or directory. If you already have a connection manager defined you can select it here. The connection mangers that populate the Source Connection Manager drop down are FILE or FLATFILE connection mangers. 

The following rules are used for a source connection / variable that contains the file or directory path:

Zip Compression - Single file or directory can be used
Z Compression - Single file can be used
Bz2 Compression - Single file can be used
GZip Compression - Single file can be used

If you choose a connection manager that contains a parth to a directory for Z, Bz2 or GZip compress you will get the following error: Validation error. Compression Task Validate: GZip, Bz2 and Z file types can only be used with file manager that have a usage type of Create File or Existing File. Directories cannot be used. 
  • Include sub directories - Available only for Zip Compression. Selecting this option will include all subdirectories within the selected variable or connection manager path.

You can select "Create New FILE Connection...>" or "Create New FLATFILE Connection...>" to create a new connection manager that will contain the path to the source file or directory. If you already have a connection manager defined you can select it here. The connection mangers that populate the Source Connection Manager drop down are FILE or FLATFILE connection mangers. 

The following rules are used for a source connection / variable that contains the file or directory path:

Zip Compression - Single file or directory can be used
Z Compression - Single file can be used
Bz2 Compression - Single file can be used
GZip Compression - Single file can be used

If you choose a connection manager that contains a parth to a directory for Z, Bz2 or GZip compress you will get the following error: Validation error. Compression Task Validate: GZip, Bz2 and Z file types can only be used with file manager that have a usage type of Create File or Existing File. Directories cannot be used. 
  • Include sub directories - Available only for Zip Compression. Selecting this option will include all subdirectories within the selected variable or connection manager path.

SSIS Compression (Zip / Unzip) Task- Step 6

Destination File Or Directory

  • Destination stored in a variable - Selecting this checkbox will replace the "Destination Connection Manager" with "Select destination variable" and the drop down will include all of the user created string variables within your package. The task will now expect the file or directory to be compressed / decompressed to be defined in the variable selected. 

Destination File Or Directory

  • Destination stored in a variable - Selecting this checkbox will replace the "Destination Connection Manager" with "Select destination variable" and the drop down will include all of the user created string variables within your package. The task will now expect the file or directory to be compressed / decompressed to be defined in the variable selected. 

SSIS Compression (Zip / Unzip) Task- Step 7
Destination connection manager - Available if "Destination stored in a variable" is not selected. The destination connection manager should point to the connection manager that points to the file or directory (zip compression only) that will be used for compression / decompression.

Destination connection manager - Available if "Destination stored in a variable" is not selected. The destination connection manager should point to the connection manager that points to the file or directory (zip compression only) that will be used for compression / decompression.

SSIS Compression (Zip / Unzip) Task- Step 8
You can select "Create New FILE Connection...>" or "Create New FLATFILE Connection...>" to create a new connection manager that point to the destination file or directory or select the a connection manger that is a FILE or FLATFILE connection manger. 

The following rules are used for a source connection / variable for the file or directory that the source points to:

Zip Compression - Single file can be used
Z Compression - Single file can be used
Bz2 Compression - Single file can be used
GZip Compression - Single file can be used

If you choose a connection manager that points to a directory for any type of compression and the task action is "Compress": Validation error. Compression Task Validate: The destination connection manager must have a Usage Type of Create File or Existing File. Directories cannot be used for the destination. 

Choosing a directory for decompression is valid ONLY for Zip and GZIP compression. Bz2 and Z files must be decompressed to a single file. 
  • Overwrite destination file - Select this if you want the compression task to overwrite the file if it already exists. If this option is not selected and the file already exists and exception will be thrown.

You can select "Create New FILE Connection...>" or "Create New FLATFILE Connection...>" to create a new connection manager that point to the destination file or directory or select the a connection manger that is a FILE or FLATFILE connection manger. 

The following rules are used for a source connection / variable for the file or directory that the source points to:

Zip Compression - Single file can be used
Z Compression - Single file can be used
Bz2 Compression - Single file can be used
GZip Compression - Single file can be used

If you choose a connection manager that points to a directory for any type of compression and the task action is "Compress": Validation error. Compression Task Validate: The destination connection manager must have a Usage Type of Create File or Existing File. Directories cannot be used for the destination. 

Choosing a directory for decompression is valid ONLY for Zip and GZIP compression. Bz2 and Z files must be decompressed to a single file. 
  • Overwrite destination file - Select this if you want the compression task to overwrite the file if it already exists. If this option is not selected and the file already exists and exception will be thrown.

SSIS Compression (Zip / Unzip) Task- Step 9
Advanced Tab 

Advanced Tab 

SSIS Compression (Zip / Unzip) Task- Step 10

Compression Settings

  • Task Action - There are two options for the Task Action:
    • Compress
    • Decompress 
  • Compression Type - There are four compression algorithms that can be used:
    • Zip
    • GZip
    • Z
    • Bz2

Compression Settings

  • Task Action - There are two options for the Task Action:
    • Compress
    • Decompress 
  • Compression Type - There are four compression algorithms that can be used:
    • Zip
    • GZip
    • Z
    • Bz2

SSIS Compression (Zip / Unzip) Task- Step 11

Zip Settings (Only available for Zip Type)

  • Compression Level - Sets the level of compression to be used during the compression process. There are 5 options:
    • None - No compression will occur. The files and directories will be added to the zip file only.
    • Fast - A small amount of compression will occur but the compression time will be fast.
    • Normal - The normal level of compression will be used.
    • Above Normal - An slighly above normal level of compression will be used. The compression time will be slower.
    • Maximum - The maximum amount of compression will occur. The compression time will be the slower than all of the other levels.
  • Password - If used with a Task Action of Compress the password specified will be added to the zip file. This password will be needed to open the zip file by and end user. If used with a Task Action of Decompress the password will be used to decompress the file selected in as the source file. 
  • Create Self-Extracting EXE - Selecting this option will create a self extracting exe instead of a zip file. 

Zip Settings (Only available for Zip Type)

  • Compression Level - Sets the level of compression to be used during the compression process. There are 5 options:
    • None - No compression will occur. The files and directories will be added to the zip file only.
    • Fast - A small amount of compression will occur but the compression time will be fast.
    • Normal - The normal level of compression will be used.
    • Above Normal - An slighly above normal level of compression will be used. The compression time will be slower.
    • Maximum - The maximum amount of compression will occur. The compression time will be the slower than all of the other levels.
  • Password - If used with a Task Action of Compress the password specified will be added to the zip file. This password will be needed to open the zip file by and end user. If used with a Task Action of Decompress the password will be used to decompress the file selected in as the source file. 
  • Create Self-Extracting EXE - Selecting this option will create a self extracting exe instead of a zip file. 

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works