EzCrypt Tasks
Properties Configuration Settings
The EzCrypt Task can be used to encrypt and decrypt data for regular transport.
Remarks
The EzCrypt 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
To use the EzCrypt Task, first select an Algorithm. Only symmetric algorithms are supported in the EzCrypt Task.
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 control the size of the key by setting the KeySize configuration setting. 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.
| Algorithm | The symmetric algorithm. |
| CipherMode | The cipher mode of operation. |
| InputFile | The full path to the input file. |
| IV | The initialization vector used by the CipherMode to modify the ciphertext. |
| Key | The secret key for the symmetric algorithm. |
| KeyPassword | A password used by the task to generate the Key and IV . |
| Other | Defines a set of configuration settings to be used by the task. |
| OutputFile | The full path to the output file. |
| Overwrite | Whether or not the component should overwrite the output file. |
| PaddingMode | The padding mode. |
| RuntimeLicense | Specifies the component runtime license key. |
| UseHex | Whether input or output is hex encoded. |
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.
| Algorithm | The symmetric algorithm. |
| CipherMode | The cipher mode of operation. |
| InputFile | The full path to the input file. |
| IV | The initialization vector used by the CipherMode to modify the ciphertext. |
| Key | The secret key for the symmetric algorithm. |
| KeyPassword | A password used by the task to generate the Key and IV . |
| Other | Defines a set of configuration settings to be used by the task. |
| OutputFile | The full path to the output file. |
| Overwrite | Whether or not the component should overwrite the output file. |
| PaddingMode | The padding mode. |
| RuntimeLicense | Specifies the component runtime license key. |
| UseHex | Whether input or output is hex encoded. |
Configuration Settings
The following is a list of configuration settings for the task with short descriptions. Click on the links for further details.
| BlockSize | The block size, in bits, of the cryptographic operation. |
| 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. |
| KeySize | The size, in bits, of secret key for the symmetric algorithm. |
| TeaAlgorithm | The TEA algorithm. |