Post reply

PGP Decryption failed when run the SSIS package from SQL Server

  • May 17, 2011 at 9:23 pm

    #238381

    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

    #1327579

    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.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply