In SSIS SQL 2005, the stored procedure to write SSIS logging informwation was
sp_dts_addlogentry. In case this sp does not exist in the logging database, it was created automatically.
When I ported a BI solution from SQL 2005 to SQL 2008, I was wondering why the logging was not working any more. Tracing the database activities with SQL Server Profile, the reason was crystal clear: they changed the name of the logging sp to
sp_ssis_addlogentry. And also, SSIS does not create it any more in case it does not exist.