I have got a problem with SSIS logging. I set up logging for my
package and its tasks separately so I can get details of the progress
and errors. I used SQL Server as log provider. The logging worked fine
when I ran the package either in a debug mode or using the Execute
Package Utility. The problem was when I deployed it to production and
have it run under a different user (a sys admin account having
sufficient rights to access the related files and database), no
detailed task-level log entries were written to the sysdtslog90 table.
That means even when the package fails, you don't see any OnError or
OnTaksFailed events but only see the PackageStart and PackageEnd
events.

Any suggestions are welcome.