SSIS Zip File Task (Zip,Unzip,Gzip compression)

SSIS Zip File Task is a FREE task which can compress or uncompress (Unzip) file in Zip or Gzip format. It supports many advanced options including multi-threads.

Features

Zip/Unzip multiple files or folders using Zip or GZip format
Support for password protected Zip files
Support multi threaded operations (Use of multiple CPU Cores)
Support for wild card pattern (e.g. File*.csv)
Support for regular expression (i.e. Regex) to include/exclude files (e.g. .exe$|.msi$ )
Support for three compression modes (NoCompression,Deflate,NoCompression)
Auto create missing target folder
Support for various encryption algorithm for password protected archives (Aes-128, Aes-192,Aes-256 and Zip20 for PKWARE encryption)

In Visual Studio, drag and drop the ZS Compression Task from SSIS Toolbox

Drag and Drop the ZS Compression Task from SSIS Toolbox

How to Create Single Archive (One for all)

SSIS Zip File Task – Zip, Gzip, Unzip, Compress multiple files and folders

After all, You can Execute Task and See Information in Execution Results

Run or Execute Task and See Information in Execution Results

Articles / Tutorials

Click here to see all articles for [SSIS Zip File Task] category

SSIS Zip File Task – Compress files and password protect

Introduction In this blog post we will see how to compress files and encrypt with password (zip and encrypt using AES algorithm). We will use SSIS Zip File Task which comes with many advanced options including encryption feature for password protected zip files. NOTE: Password feature is only available for Zip file format. If you […]