Help Needed: I am able to decrypt file when I run package manually but when I run through sql sever agent, it is not decrypting.

[Pankaj Kumar. Chaurasia]

Any clue guys. I am using version 2.3.3.


Thanks & Regards,

Pankaj K Chaurasia
Sr. Database Developer
Smart Utility Systems
0120-4208528 (O)  |  +91- 8109510013 (M) |  +91- 9406929510 (M)
pankaj.chaurasia at smartusys.com<mailto:pankaj.chaurasia at smartusys.com>  | www.smartusys.com<http://www.smartusys.com/>

[csWeekSIg0.1.3]<http://www.csweek.org/web/Online/Sponsors/Conference/Sponsors.aspx?hkey=b73645d5-c221-4c07-89bd-e3801c44fa07>

[facebook]<https://www.facebook.com/Smart-Utility-Systems-1680179402196537/?fref=ts>[linkedin]<https://www.linkedin.com/company/smart-utility-systems> [twitter] <https://twitter.com/smartutilitysys>  [google] <https://plus.google.com/117439786582055895986>

This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.
P Please consider the environment before printing this email.

From: Pankaj Kumar. Chaurasia
Sent: Friday, March 10, 2017 2:53 PM
To: 'gnupg-users at gnupg.org'
Subject: Help Needed: I am able to decrypt file when I run package manually but when I run through sql sever agent, it is not decrypting.

Hello Gnupg Users,

I am writing this mail regarding the issue facing to decrypt file through my SSIS Package.

Below is the command I am using:

gpg2.exe --batch --yes --status-fd 2 --passphrase-fd 0 --armor --output E:\File.csv --decrypt E:\File.pgp

When I run my SSIS package manually through visual studio it is decrypting the file properly. When I deploying the package on the same machine it is not decrypting. After spending to much time I come to know that the reason behind this is, I have imported the public key using command line, so it is imported for my user as I login on that machine with my windows user. But SQL Server agent job runs with MSSQL Agent Service account so I need to import the key for that service account.

Could you guys please let me know how to import the public key for that account as I cannot login with that Service account.

Thanks in Advance.

Thanks & Regards,

Pankaj K Chaurasia
Sr. Database Developer
Smart Utility Systems
0120-4208528 (O)  |  +91- 8109510013 (M) |  +91- 9406929510 (M)
pankaj.chaurasia at smartusys.com<mailto:pankaj.chaurasia at smartusys.com>  | www.smartusys.com<http://www.smartusys.com/>

[https://www.smartusys.com/emails/ISGW/signature/ISGW_EmailBanner.png]<http://www.isgw.in/events/india-smart-grid-week-2017/custom-18-8cf554ea2c054ba49a5104c64441044d.aspx>

[facebook]<https://www.facebook.com/Smart-Utility-Systems-1680179402196537/?fref=ts>[linkedin]<https://www.linkedin.com/company/smart-utility-systems> [twitter] <https://twitter.com/smartutilitysys>  [google] <https://plus.google.com/117439786582055895986>

This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.
P Please consider the environment before printing this email.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/attachments/20170317/5e580f70/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 76121 bytes
Desc: image005.png
URL: </pipermail/attachments/20170317/5e580f70/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.png
Type: image/png
Size: 1147 bytes
Desc: image006.png
URL: </pipermail/attachments/20170317/5e580f70/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.png
Type: image/png
Size: 1240 bytes
Desc: image007.png
URL: </pipermail/attachments/20170317/5e580f70/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image008.png
Type: image/png
Size: 1270 bytes
Desc: image008.png
URL: </pipermail/attachments/20170317/5e580f70/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image009.png
Type: image/png
Size: 1669 bytes
Desc: image009.png
URL: </pipermail/attachments/20170317/5e580f70/attachment-0009.png>