Tuesday, September 11, 2012

GPG File Encryption in SSIS


Using GPG File Encryption in SSIS


Step 1: First install gnupg-w32cli-1.4.9.exe (or latest version) GPG tool in your system.


Step 2: Create a new ssis package.


Step 3: Add ExecuteProcessTask. 


Step 4: To encrypt a file, configure Execute Process task as shown below:


Executables: C:\Program Files (x86)\GNU\GnuPG\gpg.exe


Arguments: --yes --always-trust  --recipient Masterworks --output  Filename.GPG --encrypt Filename.txt

WorkingDirectory: D:\File Path....

Step 4A: To decrypt a file, add below code in arguments:


--yes --always-trust --passphrase xxxxxx --output Filename.txt -d Filenname.GPG


Enter your GPG password in place of xxxxxxx .

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.