AES Tasks

Properties   Configuration Settings  

The AES Task can be used to encrypt and decrypt data for regular transport.

Remarks

The AES Task contains an encoder and a decoder that receive SSIS ADO tables from the SSIS Package and perform cryptographic operations on the data. The encoder will produce an encrypted file that the decoder can then decrypt, making it possible to add secure storage to your business process.

Configuration

Since AES is a symmetric-key algorithm, the settings for the Encode operations and Decode operations are the exact same.

First set the KeySize to determine the strength of the cipher to be used. Next, set the KeyPassword to allow the task to generate the cryptographic Key and IV. Alternatively, you may set the Key and IV properties directly. Note that the same password may be used for the encoder and decoder to generate the same key and IV.

You can change how the cryptography is performed by setting the CipherMode and PaddingMode properties.

Encoder Property List


The following is the full list of the properties of the encoder task with short descriptions. Click on the links for further details.

AdditionalAuthDataAdditional authentication data (AAD) used in GCM mode.
CipherModeControls how the task uses the IV to modify the cipher algorithm.
InputFileThe full path to the input file.
IVThe initialization vector used by the CipherMode to modify the ciphertext.
KeyThe raw key used by the cipher.
KeyPasswordA password used by the task to generate the Key and IV .
KeySizeThe size of the Key .
OtherDefines a set of configuration settings to be used by the task.
OutputFileThe full path to the output file.
PaddingModeUsed by the cipher to pad the last block of input text.
RuntimeLicenseSpecifies the task runtime license key.

Decoder Property List


The following is the full list of the properties of the decoder task with short descriptions. Click on the links for further details.

AdditionalAuthDataAdditional authentication data (AAD) used in GCM mode.
CipherModeControls how the task uses the IV to modify the cipher algorithm.
InputFileThe full path to the input file.
IVThe initialization vector used by the CipherMode to modify the ciphertext.
KeyThe raw key used by the cipher.
KeyPasswordA password used by the task to generate the Key and IV .
KeySizeThe size of the Key .
OtherDefines a set of configuration settings to be used by the task.
OutputFileThe full path to the output file.
PaddingModeUsed by the cipher to pad the last block of input text.
RuntimeLicenseSpecifies the task runtime license key.

Configuration Settings


The following is a list of configuration settings for the task with short descriptions. Click on the links for further details.

AuthTagLengthThe authentication tag length used in GCM mode.
IncludeIVWhether to prepend the IV to the output data and read the IV from the input data.
KeyPasswordAlgorithmThe hash algorithm used to derive the Key and IV from the KeyPassword property.
KeyPasswordIterationsThe number of iterations performed when using KeyPassword to derive the Key and IV.
KeyPasswordSaltThe salt value used in conjunction with the KeyPassword to derive the Key and IV.

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