Package Logging of Deployed Package on SQL server

Question

Hi,

As I know, in SSIS package development in Visual studio, logging is available as an option to log any types of message into table dbo.sysssislog. However, when I deployed the package on SQL server and run the package on SSMS, I could not see the table generated in 'System Tables'. Is the logging option in VS not applicable for deployed package? If so, what would be a simple way to log message into a table when executing a package deployed on SQL server? I know Event handler might help, but I have not test on it.

Many thanks for help.

Answer 1

Hi @TC ,

I tested locally that if I run the package via SSMS, the sysssislog will also log the files.

Please double check the system table in your database.

You can find the dbo.sysssislog table in the system tables of the database that you have configured for the SSIS package logging.

Refence: overview-of-ssis-package-logging

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.