I am using SSIS to generate files and need to encrypt them afterwards in preparation for ftp. At this time, I manually encrypt them each time prior to ftp. Does anyone know how to incorporate PGP in SSIS to encrypt files as part of the SSIS package? Or other process like powershell that can be scheduled to encrypt files automatically? Thank you!
Hi Ming Lu,
it is possible to use the gpg.exe to do command line operations, which should be good enough for simple tasks.
https://wiki.gnupg.org/TroubleShooting
has two hints about this:
- Windows > 8 and Server 2012 Task Scheduler Problems
- https://wiki.gnupg.org/TroubleShooting#Command_line_operations
Regards,
Bernhard