May 17, 2011 at 9:23 pm
Hello friends
I have set the pgp environment, passed the arguments, set the working folder. When i run the SSIS package from development environment , the decryption process is running perfectly. But, when i try to call the same SSIS package from a stored procedure (SQL SERVER) , I am getting an error and the file is not decrypting. I am sure my batch file is executing because before the decrypt command i am deleting an exsisitng file. Only problem is in this command
echo *******| gpg --passphrase-fd 0 --decrypt-files "\Files_Import\FTP\%1.txt.pgp"
The error msg is "The process exit code was "2" while the expected was "0"."
waiting for the reply......
May 20, 2011 at 5:53 am
In what process and under what user account is the sql stored procedure running? The gpg application requires full user profile and access to the folders where your public/private key rings are stored.
For a simpler and better integrated alternative I would recommend you check the commercial CozyRoc OpenPGP Task. It doesn't have issues like the above.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy