August 24, 2016 at 4:18 pm
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.
August 28, 2016 at 4:06 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply