DTS Packages Error log details Findings.

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'


Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: