Solved

GNU Privacy Guard automation of file encryption?

Posted on 2012-03-25
2
404 Views
Last Modified: 2012-04-11
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
Comment
Question by:TeknikDev
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 38

Expert Comment

by:Rich Rumble
ID: 37765222
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
 
LVL 64

Accepted Solution

by:
btan earned 500 total points
ID: 37766565
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

Is your NGFW recommended by NSS Labs?

Ours is! NSS Labs Next Generation Firewall Test gives the WatchGuard Firebox M4600 a "Recommended" rating! Curious where your NGFW landed on the  Security Value Map? See the map and download the full report today!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recovering from what the press called "the largest-ever cyber-attack", IT departments worldwide are discussing ways to defend against this in the future. In this process, many people are looking for immediate actions while, instead, they need to tho…
There is a lot to be said for protecting yourself and your accounts with 2 factor authentication.  I found to my own chagrin, that there is a big downside as well.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question