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.