• PJ_SQL (8/24/2016)


    When I run the SSIS package it runs succesfully, if I use proxy (my credentials) it runs fine from SQL Agent.

    But, if I use SQL Agent Service to run the SSIS package it fails with this error message:

    Error: 2016-08-24 16:56:57.99 Code: 0xC0029151 Source: Decrypt file Execute Process Task Description: In Executing "C:\Program Files (x86)\GNU\GnuPG\gpg2.exe" "--output F:\Ele\test\PT_08212016_1 -d F:\Ele\PT_08212016_1.pgp" at "C:\Program Files (x86)\GNU\GnuPG\", The process exit code was "2" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 4:56:55 PM Finished: 4:56:57 PM Elapsed: 2.262 seconds. The package execution failed. The step failed.

    Make sure the SQL Agent service account has access to all of the file locations as well as gpg2.exe.

    Sue