GNP and SSIS on different machines
Posted on 2012-04-11
Im struggling to get this to work. Currently trying to use GNU Privacy Guard and SQL Server SSIS.
Currently I create an SSIS package to extract data into an excel file on Machine A. Which is encrypted and posted to an FTP site for retrieval.
On Machine B has the GNU Privacy Guard application installed.
On Machine C has the SSIS installed and calls the application on Machine B. However, the key I believe is sitting somewhere on Machine B. The SSIS fails on encryption saying invalid or missing key.
The logic of why there are three separate machines is due to company policy, restriction as to what can be installed on certain machines. For instance, Machine C is a dedicated SQL Server box.
Anyways, does anyone have any idea how I can make this work? Could I copy the key from Machine B and paste it somewhere on Machine C so that it has the key to encrypt the file?