Because SSIS (2008) only writes to one system table we decided to write our package logs to flat files on the database server then add a step to import those flat files to specific tables in the appropriate databases so the import logs were with the relevant project. We then run a specific query to pick out errors which is part of the daily check routine.