I have a SSIS package that does a GPG decrypt in a Process Task.
It runs without any problems both in Visual Studio (BIDS) and when I run same SSIS package via SQL Server agent (SQL SERVER 2008 R2) it is failed.
error : The process exit code was “2” while the expected was “0”.
Could please help me, how to setup these SSIS job in Sql sever agent and run successful?
Thanks is advance.