My DBA upgraded our server from 2005 to 2008 and when it did my SSIS packages stopped logging messages.
Problem 1:
Well the default logging mechanism in 2005 logs to the dbo.sysdtslog90 table. Well in 2008 they changed the table name to dbo.sysssislog. Not a big deal, but you will never find something if you look in the wrong place.
Problem 2:
Well now that I am looking at the right table, I noticed that my events were NOT showing up. In particular I was looking for the OnPreExecute and OnPostExecute methods. Poof gone, after many searches I stumbled across the following posts:
https://connect.microsoft.com/SQLServer/feedback/details/491508/logging-of-ssis-tasks-are-incomplete-when-run-by-sql-agent-job?wa=wsignin1.0
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/511502a6-99d6-4693-94da-2c317c3f59c6
Ahh, bug in SSIS, I am not nuts, whew, now what. Well on the forum John Welch suggests adding event handlers to the package and using an Execute SQL task to log the event. I only have two packages, it is late, while painful, I will do that. However, by dumb luck I forgot to add the SQL Task to one of my packages, and it still worked. Interesting.
So long story short all I needed to do was add the event handlers, nothing else.
So my package when from this:
To This:
and Poof Success!