Home Forums SQL Server 2005 SQL Server 2005 Integration Services Execute Process Task - The process exit code was "2" while the expected was "0" RE: Execute Process Task - The process exit code was "2" while the expected was "0"

  • July 2, 2009 at 10:09 am

    #1019288

    We have a Process Task component setup in a couple SSIS jobs to call a GNU (gpg.exe) for decryption. The process works fine if we start the SQL Agent job (both manually or schedule) under the proxy setup account only when we leave a login session open on the server (login is the proxy account).

    The process fails if there are no login session open on the server.

    The exact error has to do with the gpg.exe unable to find a particular security file.

    It appears the issue is associated with a need to find the security key file in the %PATH% . Is the path specified in the system enviroment available to SSIS? if not how can one specify the path? Thanks.