Technical Article

Check DTS Package Logs for Errors

,

Replace the date and run on server.

use msdb
go

SELECT *
FROM sysdtspackagelog
WHERE (logdate > CONVERT(DATETIME, '2008-05-19 00:00:00', 102)) AND (errorcode <> 0)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating