[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

GNU Privacy Guard automation of file encryption?

Posted on 2012-03-25
2
Medium Priority
?
408 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
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 65

Accepted Solution

by:
btan earned 2000 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

Put Machine Learning to Work--Protect Your Clients

Machine learning means Smarter Cybersecurity™ Solutions.
As technology continues to advance, managing and analyzing massive data sets just can’t be accomplished by humans alone. It requires huge amounts of memory and storage, as well as high-speed processing of the cloud.

Question has a verified solution.

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

Experts Exchange expands question security options for members.
Securing your business data in current era should be your biggest priority. Numerous people are unaware of the fact that insiders commit more than 60 percent of security breaches. You need to figure out the underlying cause and invoke your potential…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

830 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