Post reply

ftp task - PGP public key

  • March 19, 2013 at 1:22 am

    #394414

    Hi,

    I am in the process of using a FTP task in my ssis package.

    This is to retrieve files from a source such as xxx.com

    The source company is saying in order for them to allow this (i.e. files to be retrieved over the internet using FTP), The files need to be PGP encrypted and so they are asking me for the PGP public key.

    Question:

    1- Does the ftp task in ssis have to do anything with this PGP public key?

    2- I have checked the properties of the ftp task and there is no setting for PGP. Is there a setting for this in ftp task?

    Any thoughts please?

    Thanks

  • March 19, 2013 at 9:28 am

    #1598500

    1- Does the ftp task in ssis have to do anything with this PGP public key?

    This has nothing to do with SSIS or FTP. PGP is an encryption technology commonly used to encrypt files exchanged between two companies, especially when using public, open networks (e.g. regular FTP over the internet) to exchange those files. You should start by reading a little about PGP (Pretty Good Privacy).

    2- I have checked the properties of the ftp task and there is no setting for PGP. Is there a setting for this in ftp task?

    In order to handle the request you will need a program in your environment capable of generating keys as well as encrypting and decrypting files using the PGP algorithm. GnuPG[/url] is a good and free option.

    Once you have generated a public/private key pair you will send your partner the public key. They can then encrypt files using that key, post them on FTP, and then when you download them you can decrypt them using the private key that is related to the public key you gave them.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 19, 2013 at 10:33 am

    #1598528

    Thanks

  • March 20, 2013 at 6:27 am

    #1598862

    A not free option that I started using last year is Robo-FTP. You can run it as a service and schedule it. It has PGP baked in.

    I use it to poll an FTP server every 10 minutes, download all PGP files found, decrypt them, then delete them from the remote server. The program and scripting language feel old school, but it all works.

    Feel free to call and ask questions before you decide.

    Good luck with your project.

  • March 23, 2013 at 7:05 pm

    #1600085

    If you can use third-party solutions, check the commercial COZYROC OpenPGP Task. It is completely integrated in SSIS and very easy to use.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply