Solved

GNU Privacy Guard automation of file encryption?

Posted on 2012-03-25
2
401 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 62

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Port 808 is being blocked 9 102
Domain admin accounts get locked out 35 61
non-domain members are not prompted for credentials 18 43
Review of a VPN cert policy 4 28
The new Gmail Phishing Scam going around is surprising even the savviest of users with its sophisticated techniques.
This article outlines the process to identify and resolve account lockout in an Active Directory environment.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
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 …

821 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