-- SQL Server 2005

select * from [YOURDB]..sysdtslog90

-- SQL Server 2008

select * from [YOURDB]..sysssislog

may be this Web Site will Help u =

=======================

http://connect.microsoft.com/SQLServer/feedback/details/467794/ssis-log-provider-for-sql-server-do-not-work-when-default-schema-is-not-dbo-sysdtslog90-sysssislog