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.
AdditionalAuthData | Additional authentication data (AAD) used in GCM mode. |
CipherMode | Controls how the task uses the IV to modify the cipher algorithm. |
InputFile | The full path to the input file. |
IV | The initialization vector used by the CipherMode to modify the ciphertext. |
Key | The raw key used by the cipher. |
KeyPassword | A password used by the task to generate the Key and IV . |
KeySize | The size of the Key . |
Other | Defines a set of configuration settings to be used by the task. |
OutputFile | The full path to the output file. |
PaddingMode | Used by the cipher to pad the last block of input text. |
RuntimeLicense | Specifies the component 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.
AdditionalAuthData | Additional authentication data (AAD) used in GCM mode. |
CipherMode | Controls how the task uses the IV to modify the cipher algorithm. |
InputFile | The full path to the input file. |
IV | The initialization vector used by the CipherMode to modify the ciphertext. |
Key | The raw key used by the cipher. |
KeyPassword | A password used by the task to generate the Key and IV . |
KeySize | The size of the Key . |
Other | Defines a set of configuration settings to be used by the task. |
OutputFile | The full path to the output file. |
PaddingMode | Used by the cipher to pad the last block of input text. |
RuntimeLicense | Specifies the component 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.
AuthTagLength | The authentication tag length used in GCM mode. |
IncludeIV | Whether to prepend the IV to the output data and read the IV from the input data. |
KeyPasswordAlgorithm | The hash algorithm used to derive the Key and IV from the KeyPassword property. |
KeyPasswordIterations | The number of iterations performed when using KeyPassword to derive the Key and IV. |
KeyPasswordSalt | The salt value used in conjunction with the KeyPassword to derive the Key and IV. |