Column Encryption Transformation

DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.

Script File:

Overview

Data flow transformation providing column encryption. The specified input columns are processed and the original content is replaced.

The script has the following parameters:

InputColumns - selects one or more input columns for processing.
Action - selects component action: Encryption or Decryption.
EncryptionType - selects encryption type: AES, RSA, TripleDES, DES, RC2.
IsCertificateFileVariable - indicates whether the certificate file path is stored in a variable.
- CertificateFile - selects certificate file.
- CertificateFileVariable - selects variable containing certificate file path.
IsPasswordVariable - indicates whether the password is stored in a variable.
- Password - specifies password.
- PasswordVariable - selects variable containing password.

Depends on COZYROC Script Component Plus component for implementing parameters user interface.