awelsh (7/9/2008)
I opened a command Prompt window and typed pgp -s filename.txt. No, I didn't set up the environment, which is why I suspect it is erroring stating it doesn't understand what pgp means.My company purchased PGP Desktop software that I should use to encrypt the data going between the client and I. I've used PGP before, and did it at the command line instead of through the GUI interface. I wanted to do that again.
The PGP software is at c:\Program Files\PGP Corporation\PGP Desktop\PGPdesk.exe. But within this software, there are many options. I want the Zip function, and from the command line I'm not sure how to tell it what I expect.
Any suggestions? I'm beginning to think the free pgp version would be easier to use in this fashion than PGP Desktop.
Amy
Amy, it appears that you have two different issues - first, you're calling PGP.exe but your environment doesn't know where to find this file, and second, you're not able to use the command line options you want.
For the first issue, you either need to set the environmental variable as the first respondent suggested, or use the full path to call PGP.exe (rather than just calling it by file name). I recommend the latter, particularly if you plan on moving your package from one machine to another.
The second issue is not really an SSIS issue but a PGP issue. I've used PGP a couple of times in SSIS packages but I can't tell you exactly what the command line parameters are. From the command line, enter the path to the PGP executable and use the Help parameter, which will normally be /? or -help. The output should explain file usage.
Hope this helps...
Tim
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices