I have downloaded and installed the CozyRoc SSIS add on for SQL Server 2012. I'm trying to leverage the Open PGP Task, but am running into issues with encrypting files.
We need to encrypt files to send to one of our vendors. They have provided us with their public key (PublicKey.asc).
I've created the package and configured the Open PGP task wit the key. The task runs successfully, but fails to encrypt the file - the contents are still visible.
When I use Kleopatra to encrypt the file with the same key, the file is successfully encrypted.
Is there some special steps when trying to encrypt files using a key other than your own?
T