CozyRoc
Overview
PGP Task is SSIS Control Flow task for encryption and decryption using the OpenPGP (RFC 2440) standard.
Setup
Use the General page of the PGP Task Editor dialog to configure the options needed to encrypt, decrypt, create or verify file signature.
Options
- Name
-
Specify task name.
- Description
-
Specify task description.
- Action
-
Specify task action. This property has the options listed in the following table.
Value Description Encrypt file Encrypts file. Selecting this value displays the dynamic options IsPublicKeyRingVariable, PublicKeyRing, PublicKeyRingVariable, Key, OutputASCII, IsSourceVariable, Source, SourceVariable, RemoveSource, IsTargetVariable, Target, TargetVariable, OverwriteExisting. Decrypt file Encrypts file. Selecting this value displays the dynamic options IsSecretKeyRingVariable, SecretKeyRing, SecretKeyRingVariable, Password, IsSourceVariable, Source, SourceVariable, IsTargetVariable, Target, TargetVariable, OverwriteExisting. Create file signature Creates file signature. Selecting this value displays the dynamic options IsSecretKeyRingVariable, SecretKeyRing, SecretKeyRingVariable, Key, Password, OutputASCII, IsSourceVariable, Source, SourceVariable, IsSignatureVariable, Signature, SignatureVariable, OverwriteExisting. Verify file signature Verifies file signature. Selecting this value displays the dynamic options IsPublicKeyRingVariable, PublicKeyRing, PublicKeyRingVariable, ResultVariable, IsSourceVariable, Source, SourceVariable, IsSignatureVariable, Signature, SignatureVariable.
- IsPublicKeyRingVariable
-
Indicates whether the public key ring path is stored in a variable. This property has the options listed in the following table.
Value Description True The public key ring path is stored in a variable. Selecting the value displays the dynamic option PublicKeyRingVariable. False The public key ring path is specified in a File connection manager. Selecting the value displays the dynamic option PublicKeyRing.
- PublicKeyRing
-
Select an existing File connection manager, or click <New connection...> to create a connection manager.
Related topics: File Connection Manager Editor
- PublicKeyRingVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- Key
-
Select key(s) from key ring.
- OutputASCII
-
Select to output 7-bit ASCII data instead of binary data.
- IsSourceVariable
-
Indicates whether the source path is stored in a variable. This property has the options listed in the following table.
Value Description True The source path is stored in a variable. Selecting the value displays the dynamic option SourceVariable. False The source path is specified in a File connection manager. Selecting the value displays the dynamic option Source.
- Source
-
Select an existing File connection manager, or click <New connection...> to create a connection manager.
Related topics: File Connection Manager Editor
- SourceVariable
-
Contains source path or input Stream object. Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- RemoveSource
-
Specify source file to be removed after encryption.
- IsTargetVariable
-
Indicates whether the target path is stored in a variable. This property has the options listed in the following table.
Value Description True The target path is stored in a variable. Selecting the value displays the dynamic option TargetVariable. False The target path is specified in a File connection manager. Selecting the value displays the dynamic option Target.
- Target
-
Select an existing File connection manager, or click <New connection...> to create a connection manager.
Related topics: File Connection Manager
- TargetVariable
-
Contains target path or output Stream object. Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- OverwriteExisting
-
Specify to overwrite existing file.
- IsSecretKeyRingVariable
-
Indicates whether the secret key ring path is stored in a variable. This property has the options listed in the following table.
Value Description True The secret key ring path is stored in a variable. Selecting the value displays the dynamic option SecretKeyRingVariable. False The secret key ring path is specified in a File connection manager. Selecting the value displays the dynamic option SecretKeyRing.
- SecretKeyRing
-
Select an existing File connection manager, or click <New connection...> to create a connection manager.
Related topics: File Connection Manager
- SecretKeyRingVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- IsSignatureVariable
-
Indicates whether the signature path is stored in a variable. This property has the options listed in the following table.
Value Description True The signature path is stored in a variable. Selecting the value displays the dynamic option SignatureVariable. False The signature path is specified in a File connection manager. Selecting the value displays the dynamic option Signature.
- Signature
-
Select an existing File connection manager, or click <New connection...> to create a connection manager.
Related topics: File Connection Manager
- SignatureVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable.
Related Topics: Integration Services Variables, Add Variable
- ResultVariable
-
Select an existing user-defined variable, or click <New variable...> to create a variable. The variable has to be type Boolean and it will contain the verificiation result.
Related Topics: Integration Services Variables, Add Variable