EncryptionAlgorithm Property

The algorithm used to encrypt a SSIS ADO table when written to the archive.

Data Type


Possible Values

Default (0)
AESWeak (1)
AESStrong (2)
AESMaximum (3)

Default Value



The algorithm used to encrypt each file written to the archive.

Note that the Password property must be set in order for the task to encrypt files. By default the task will use standard zip encryption if Password is set, and will not encrypt data otherwise.

The task supports the use of AES, the Advanced Encryption Standard, as well as standard Zip encryption. The default encryption algorithm is the algorithm introduced in version 2.0 of the Zip specification, and is compatible with virtually all other zip utilities. However, this algorithm is considered weak and should not be used to protect sensitive data.

AES is a U.S. government standard cleared to protect even the most sensitive data. The file format used to create AES-encrypted files is designed to be compatible with WinZip 9.0. AES-encrypted files created by the task may or may not be compatible with other Zip utilities.

The task supports the use of AES with key lengths of 128, 192, or 256 bits. Note that even with the weakest (128-bit) keys, AES is much more secure than standard Zip encryption.

If you use strong or maximum AES encryption, the task will generate a unique salt value and cryptographic key for each file encrypted. If you use weak encryption the task will use the same salt for each file in the archive. If you are encrypting a large number of files, this will have a substantial effect on performance.

If using AES encryption it is important to choose a good Password. For 128-bit keys it is recommended that your password be 32 characters long, and for 256-bit keys, 64 characters.

Important: Note that AES encryption only encrypts the contents of encrypted files within the Zip archive; it does not prevent an attacker from reading the names of files in the archive, or from adding or deleting files to or from the archive. To prevent this consider first storing your files in an unencrypted zip file, and then storing this zipped file in another, AES-encrypted zip file.

Property values:


This property is not available in the Disassembler/Decoder.

Copyright (c) 2021 /n software inc. - All rights reserved.
/n software Tasks for SSIS - Version 20.0 [Build 7877]