SSIS Logging Issue: Proxy Account Does Not Write to sysssislog Tabl

PAVEL WILFREDO SALAZAR CORTEZ 0 Reputation points
2025-01-22T21:57:47.72+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,400 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,638 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.