|
SSIS Zip File Task (GZip,Zip,Unzip)
|
 
|
|
SSIS Zip File Task can compress or uncompress (Unzip) file in Zip or Gzip format. It supports many advanced options including multi-threads.
|
Note: If you want to operation with multiple files then use wildcard pattern as below (when you use wildcard pattern in source path then system will treat target path as folder regardless you end with slash).
Examples:
c:\data\file123.txt (single file) c:\data\file*.txt (all files starting with file) c:\data\subfolder\*.txt (all the files with Extension txt and located under folder subfolder)
| Property Name | Description | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Action | Specifies what action you want to perform
|
||||||||||||||||||||||||||||||
| SourcePathAccessMode | Path access mode for file/folder
|
||||||||||||||||||||||||||||||
| SourcePathValue | Source path or pattern | ||||||||||||||||||||||||||||||
| SourcePathConnection | Connection name which holds source path | ||||||||||||||||||||||||||||||
| SourcePathVariable | Variable name which holds source path/pattern | ||||||||||||||||||||||||||||||
| Recursive | Specifies how to handle scanning of items | ||||||||||||||||||||||||||||||
| TargetPathAccessMode | Path access mode for file/folder
|
||||||||||||||||||||||||||||||
| TargetPathValue | Specifies target path | ||||||||||||||||||||||||||||||
| TargetPathConnection | Specifies target path | ||||||||||||||||||||||||||||||
| TargetPathVariable | Specifies target path | ||||||||||||||||||||||||||||||
| OverwriteAction | Specifies how to handle overwrite action
|
||||||||||||||||||||||||||||||
| ArchiveFormat | Compression file format
|
||||||||||||||||||||||||||||||
| CreateMissingTargetFolder | Specify this option if you want to create target folder automatically if its missing | ||||||||||||||||||||||||||||||
| EncryptionAlgorithm | Specifies the encryption algorithm used to encrypt data.
|
||||||||||||||||||||||||||||||
| CompressionLevel | Gets or sets the compression level to be used by Add(String) and AddFile(String) methods. Pick right option to balance speed vs size. For example FastCompression can reduce time to compress but wont give you good compression ration. On the other end BestCompression will give you high compression ration but will take longer to compress. Choose right setting based on your need.
|
||||||||||||||||||||||||||||||
| LocalHeaderVerificationMode | Gets or sets the compression header verification mode. Change this to None (Do not verify) if you have malformed Zip file and you like to continue operation without failing.
|
||||||||||||||||||||||||||||||
| CompressionMethod | Compression method to be used
|
||||||||||||||||||||||||||||||
| Comment | Comment for the whole ZIP archive | ||||||||||||||||||||||||||||||
| Password | Specifies the encryption algorithm used to encrypt data. | ||||||||||||||||||||||||||||||
| ParallelThreads | Sets the number of parallel compressors to use when compressing data. Multiple compressors take advantage of modern multi-core CPUs and substantially enhance compression speed. | ||||||||||||||||||||||||||||||
| ExcludeRegXPattern | Regular expression pattern to exclude items from selection (if you apply MyFile*.* filter for source path and then use ExcludeRegXPattern=(\.msi$|\.exe$) then it will include all files with matching name but exclude *.msi and *.exe | ||||||||||||||||||||||||||||||
| IncludeRegXPattern | Regular expression pattern to include items from selection (if you apply MyFile*.* filter for source path and then use IncludeRegXPattern=(\.txt$|\.csv$) then it will include only txt and csv files with matching name pattern | ||||||||||||||||||||||||||||||
| TreatRegXForFullPath | Treat include/exclude Regular Expression as Full Path expression rather than file name. If you have a use case of checking against Folder name pattern along with file name then use this option. When you check this option then using ^ in the front of expression will not work for File name pattern so instead of something like this ^MyFile\w+\.csv$ you need to change prefix check like this [\\|/]MyFile\w+\.csv$ this way it works against full path check. | ||||||||||||||||||||||||||||||
| SortBy | Property by which you want to sort result
|
||||||||||||||||||||||||||||||
| SortDirection | Sort order (e.g. Ascending or Descending)
|
||||||||||||||||||||||||||||||
| WhereClause | Where clause expression to filter items. (e.g. Size>100 and Extension IN ('.txt','.csv') ) | ||||||||||||||||||||||||||||||
| EnableSort | Sort items by specified attribute | ||||||||||||||||||||||||||||||
| MaxItems | Maximum items to return (e.g. TOP) | ||||||||||||||||||||||||||||||
| SkipItems | Maximum items to skip (e.g. SKIP) | ||||||||||||||||||||||||||||||
| LoggingMode |
|
||||||||||||||||||||||||||||||
| PrefixTimestamp | When you enable this property it will prefix timestamp before Log messages. |
|
SSIS Zip File Task – Compress files and password protectIntroduction 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 […] |
