Having issues with running an SSIS job with SQL Server Agent. The part that is failing is a simple file encryption process but that part will only work when the user that the job is running under is logged into the server. The SQL server is 2017 and the PGP flavor is GnuPG. I can run the job on the server from a command line when logged in. I can run the job from Visual Studio as any user. I am thinking the system cannot access the keyring if the user is not logged in.
I have tried using both a process execution task and writing to the cmd.exe in a script task. Each of these works fine if the user is logged in. I did see somewhere that GnuPG was supposed to be supporting --recipient-file and I tried exporting the .asc file out of the ring, but I get an error that the --recipient-file option is invalid.
Any ideas for a different PGP installation that might be less profile dependent? Lots of flavors out there. Thanks.