Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ftp task - PGP public key Expand / Collapse
Author
Message
Posted Tuesday, March 19, 2013 1:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:47 AM
Points: 152, Visits: 197
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
Post #1432502
Posted Tuesday, March 19, 2013 9:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:41 PM
Points: 7,098, Visits: 12,607
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 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
Post #1432736
Posted Tuesday, March 19, 2013 10:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 2:47 AM
Points: 152, Visits: 197
Thanks
Post #1432769
Posted Wednesday, March 20, 2013 6:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, August 22, 2014 11:28 AM
Points: 4, Visits: 83
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.
Post #1433171
Posted Saturday, March 23, 2013 7:05 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 3:26 PM
Points: 1,117, Visits: 2,221
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/

Post #1434638
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse