• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1500
  • Last Modified:

GPG decryption in SSIS Execute Process - prompting for Passphrase even though I'm passing it in

I have an Execute Process task within a SSIS Package, where I am executing gpg.exe.

My StandardInputVariable is User::Passphrase (which contains my Passphrase)

My Arguments string is as follows:
--passphrase-fd 0 --output "C:\...OutputFilePath" --yes --decrypt "C:\...FileToDecryptPath"

At one point everything was working fine, however now I'm getting prompted by GPG to enter my Passphrase, even though I'm passing it in. This happens if I run the Package locally, or run it scheduled as a SQL Job.

I'm going crazy here trying to figure this out, any help would be greatly appreciated. Thanks!

Matt

0
mattPlymouth
Asked:
mattPlymouth
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
please check the task
0
 
mattPlymouthAuthor Commented:
What do you mean by check the task?
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
Hi,
Try to run it from BIDS, set a checkpoint and watch for the variable when it changes, and try to troubleshoot that.

once I've followed this article http://codingstuffs.blogspot.com/2007/03/pgp-inside-ssis-package.html when I was implementing that.

That's the only thing I can think of!

Jason
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
Hi,

Any luck? need more info?

Regards,
Jason Yousef
0
 
James MurrellProduct SpecialistCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now