Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole

Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area



Buy Now Free Trial Download Compare Editions

Task Factory PGP Encryption Task

The PGP Task brings easy to use PGP encryption, decryption, file signing and verification to SSIS that is based on OpenPGP technology.

Feature Highlights

  • File encryption - The PGP Task can encrypt a file that can be sent securely increasing the security available around transporting files through FTP and Email.
  • File decryption - The PGP Task can be used to decrypt a file sent to your system.
  • File signing - The PGP Task can sign a file to allow an end user / system to be able to verify the file being sent was actually created your system.
  • File verification - The PGP Task can verify the signature of a file sent to your system from a client. This will allow you to verify the file actually was created by the client and not hacked by something else and sent to your system.
SSIS PGP Encryption Task

SSIS PGP Encryption Task- Step 1
Encrypting a file using the PGP Task

Encrypting a file using the PGP Task

SSIS PGP Encryption Task- Step 2

The PGP Task can be used to encrypt a file using PGP encryption. There are several options when using the encryption mode of the pgp task. The definition of the UI options are below.

Select the source file to be encrypted

  • File location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the source file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.
  • Source file contains a signature - With the PGPTask it's possible to create a file with a signature that is part of the file. Choose this option if the task will encrypt a file with a signature.
  • Remove source file after encryption - This option will remove the source file after the encryption process is finished.

Select the destination file of the encrypted file

  • Destination location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the destination file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.
  • Overwrite the file if it already exists - Checking this option will overwrite the destination file if the file already exists. If the file exists and this option isn't selected then the task will fail.
  • Save the file as text / ascii - Check this option if the task will encrypt text and the text needs to be transmitted in an email or read by another text decryption program
  • Encrypt using PGP Version 2 (Old Version) - This option is for legacy systems that need to decrypt the file using the old format of PGP

Select the public key ring to file to be encrypted

  • Public key ring is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the public key ring file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the public key ring file.
  • Select public keys you want to use to encrypt this file - This is where the available public keys from the public key ring file will be displayed. At least one public key must be select to encrypt the file. Multiple public keys can be used to encrypt the file.

The PGP Task can be used to encrypt a file using PGP encryption. There are several options when using the encryption mode of the pgp task. The definition of the UI options are below.

Select the source file to be encrypted

  • File location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the source file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.
  • Source file contains a signature - With the PGPTask it's possible to create a file with a signature that is part of the file. Choose this option if the task will encrypt a file with a signature.
  • Remove source file after encryption - This option will remove the source file after the encryption process is finished.

Select the destination file of the encrypted file

  • Destination location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the destination file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.
  • Overwrite the file if it already exists - Checking this option will overwrite the destination file if the file already exists. If the file exists and this option isn't selected then the task will fail.
  • Save the file as text / ascii - Check this option if the task will encrypt text and the text needs to be transmitted in an email or read by another text decryption program
  • Encrypt using PGP Version 2 (Old Version) - This option is for legacy systems that need to decrypt the file using the old format of PGP

Select the public key ring to file to be encrypted

  • Public key ring is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the public key ring file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the public key ring file.
  • Select public keys you want to use to encrypt this file - This is where the available public keys from the public key ring file will be displayed. At least one public key must be select to encrypt the file. Multiple public keys can be used to encrypt the file.

SSIS PGP Encryption Task- Step 3

The PGP Task can be used to decrypt a file that was encrypted using PGP. The decryption option not only allows the user to decrypt the file but to also verify the file signature if a signature was embedded in the encrypted file.

Select the source file to be decrypted

  • File location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the source file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.

Select the destination file of the decryption file

  • Destination location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the destination file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.
  • Overwrite the file if it already exists - Checking this option will overwrite the destination file if the file already exists. If the file exists and this option isn't selected then the task will fail.

Select the private key ring to decrypt file

  • Is the private key ring file stored key stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the private key ring file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the public key ring file.
  • Private key password -  This is the password associated with the private key selected.

Verify signature file

This option is only used if the file being decrypted has a file signature embedded within it's contents.

  • Verify file signature - Checking this option will cause the task to look for an embedded file signature and verify it was signed using the public key ring selected
  • Is public key ring file location stored in a variable -Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the public key ring must be stored in the variable selected

The PGP Task can be used to decrypt a file that was encrypted using PGP. The decryption option not only allows the user to decrypt the file but to also verify the file signature if a signature was embedded in the encrypted file.

Select the source file to be decrypted

  • File location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the source file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.

Select the destination file of the decryption file

  • Destination location is stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the destination file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the source file.
  • Overwrite the file if it already exists - Checking this option will overwrite the destination file if the file already exists. If the file exists and this option isn't selected then the task will fail.

Select the private key ring to decrypt file

  • Is the private key ring file stored key stored in a variable - Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the private key ring file must be stored in the variable selected
  • Select connection manager - Select or create a connection manager that points to the public key ring file.
  • Private key password -  This is the password associated with the private key selected.

Verify signature file

This option is only used if the file being decrypted has a file signature embedded within it's contents.

  • Verify file signature - Checking this option will cause the task to look for an embedded file signature and verify it was signed using the public key ring selected
  • Is public key ring file location stored in a variable -Checking this option will change the "Select connection manager" drop to a drop down containing the string variables in the ssis package. The location of the public key ring must be stored in the variable selected

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works