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!