I enabled logging on one of my packages and pointed it to SQL Server. I confirmed that I added logging for OnError, OnPreExecute and OnPostExecute events and the package runs fine. But when I go over to SSMS to view the results, I dont see the table itself with MSDB or any other databases.
What am I missing??
Never mind. I was looking at the wrong database. I thought that sysssislog table was created by default on the msdb database, but turns out it was created within a different database.
If you face a similar issue, you would want to look for a few things:
1) If any of the events are being captured or not within the Logging window. Make sure the appropriate tasks are being logged and the appropriate details within are also being captured.
2) Check the connection string and make sure that you have appropriate permissions on the database that you are writing to.
3) If you still dont see it working, try a different logging method (writing to a text file) and this should clear up if permissions are an issue or if its something else.