OK...before you guys say anthing, I've got a Proxy that runs the package as the exact same user I use when I log in. So I don't think it's a permissions issue, That being said...
In my Execute Process Taks Editor you'd see the following values.
Executable:
C:\Program Files\GNU\GnuPG2\gpg.exe
Arguments:
--passphrase-fd 0 --decrypt-files FILETOBEDECRYPTED
Standard Input Variable:
(a variable containing my passphrase)
The success Value is set to 2 because the originator doesn't sign the file before they send it...(I think)
The Problem w/ doing this is just rolls right past w/ out decrypting anything.
Everything works great when I run the script in a command window, and when i run it in Visual Studio, however, when it's run in a SQL Agent Job it just doesn't do anything. The log progresses as if it worked, but nothing is being done.
Is there a better way to debug this?
Thanks in advance.
Start Free Trial
