DTLoggedExec is a great add-in that replaces DTExec within SSIS that adds very good logging. Davide has reported on his blog (http://sqlblog.com/blogs/davide_mauri/) that the product is very stable and very nearly ready to come out of beta. Read about the latest release here - http://sqlblog.com/blogs/davide_mauri/archive/2009/11/28/dtloggedexec-0-2-3-0-beta-published.aspx.
Enjoy,
-Kevi