• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • Last Modified:

GNU Privacy Guard automation of file encryption?

I was tasked to automate an encryption of a data extraction output. It's basically a query to a SQL table and saved as a .csv file. Then I want to be able to use GNU Privacy Guard and encrypt the file.

Is there anyway to automate this process? I was maybe SSIS and then use xp_sendmail (Transact-SQL)
to send the email with the file attached.
0
TeknikDev
Asked:
TeknikDev
1 Solution
 
Rich RumbleSecurity SamuraiCommented:
What sort of information, is it subject to any additional laws or regulations like FISMA(gov't), PCI(creditcard/SSN), HIPAA(patient/doctor)? Is Public key cryptography required or will password protection do? GPG/PGP can be complex to setup and maintain the keys and their exchanges, especially with non-tech savvy folk. We like to use AES-256 bit encryption from 7zip and maintain an offline list of passwords (printed to paper as opposed to keeping on a PC).
-rich
0
 
btanExec ConsultantCommented:
There is command line avail
 http://www.glump.net/howto/gpg_intro#encrypting_and_decrypting_files
Probably a bat file after the csv for encryption and even sending email out
0

Featured Post

The Firewall Audit Checklist

Preparing for a firewall audit today is almost impossible.
AlgoSec, together with some of the largest global organizations and auditors, has created a checklist to follow when preparing for your firewall audit. Simplify risk mitigation while staying compliant all of the time!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now