SSIS Logging Issue: Proxy Account Does Not Write to sysssislog Tabl
SSIS logging has been set up in the package. When running the package in SQL Server Data Tools (SSDT), it writes to the sysssislog table without any issues. After publishing it to SSIS and running it using the SQL Server Agent account, it again writes to the sysssislog table. However, when running the package as a proxy account, it no longer writes to that table and does not generate any errors.
The credential for the proxy account is assigned db_owner on the database used in the connection, and execute permissions on dbo.sp_ssis_addlogentry
have been granted on both the database and MSDB as a precaution, yet it still does not work. If the credential is granted SysAdmin privileges on the server, it writes to the table successfully, but this level of access is not desirable for a proxy account.
What permissions might be missing that prevent the proxy account from writing to the sysssislog table? I suspect this issue relates to the system-level permissions required for proxy accounts to run SSIS jobs, as there are end users (who are not SysAdmin or db_owners) able to run the SSIS package from SSDT and write to the sysssislog table.