How to view dtspackage error log in a table?

select * from msdb..sysdtssteplog order by endtime desc

select * from msdb..sysdtstasklog order by endtime desc

select * from msdb..sysdtspackagelog order by logdate desc

How to find dtspackage owner name ?

select * from msdb..sysdtspackages where name ='dtspackagename'

Hope above query will help.

Kumar

http:\\sqldbataskwithkumar.blogspot.com