sql server dts: I have a DTS package that executes every 10 min. How can I
create automated way to remove oldest PackageLogs from SQL
server?

Thank you,

Yelena

The SQL Server based logs are held in three tables within the msdb database-

dbo.sysdtspackagelog
dbo.sysdtssteplog
dbo.sysdtstasklog

The relationship between the three is fairly obvious, but you only need
delete from sysdtspackagelog a there are FKs with the cascading delete
option set for the other two tables. Sample code-

DELETE dbo.sysdtspackagelog
WHERE logdate < DATEADD(hh, -24, CURRENT_TIMESTAMP)


--
Darren Green
http://www.sqldts.com


[quoted text, click to view]