none
Pgp and SSIS

    Question

  • Requirement :

    How can we PGP encrypt a file in SSIS and then supply the file to the user and ask the user to open the file  without any software program but with a password ?

    E.g Say I encrypted a csv file using SSIS and then supplied this file to user via email .Now how can the user open the file ? Does he need the keys and the password or the keys must be installed with a pgp encryption\decryption software on his machine.Can he decrypt with the keys and without any decryption software.

    My research so far says we can PGP encrypt a file using public and private keys and set a password and then use one of the Public\private key with the password to decrypt it using the same software which was used for encryption.






    • Edited by MLTC Friday, February 09, 2018 3:31 PM
    Friday, February 09, 2018 3:28 PM

Answers

  • I you are exchanging encrypted files then PGP public/private key encryption is what you need. The receiver of the files generates a public/private set of keys using any PGP compatible software and sends you the public key. You then use that key to encrypt the file and send it to the receiver. Only someone with the private key can decrypt the file. 

    To do this within SSIS you will need to use the Execute Process task combined with one of the many free PGP encryption programs out there.

    There are many references on the web on how to accomplish this. Here is one for starters:

    https://www.sqlservercentral.com/Forums/Topic365090-148-1.aspx

    CozyRoc also sells a encryption component which greatly simplifies the process of encrypting files. I have used it before and it is excellent.

    • Marked as answer by MLTC Monday, February 12, 2018 3:53 PM
    Saturday, February 10, 2018 4:45 PM

All replies