Hi, anyone know of anyway to purge DTS Logs up to certain
date? The key thing here is I need to automate this job
instead of manually deleting the logs from Enterprise Manager.

Thanks in advanced

rgds,
Hoon

In message <fd9c01c3f361$d2454c40$a101280a (AT) phx (DOT) gbl>, Hoon
<anonymous (AT) discussions (DOT) microsoft.com> writes
The logs are all in tables in msdb, dbo.sysdtspackagelog,
dbo.sysdtssteplog, dbo.sysdtstasklog, so you can write your own delete
statements with the logic you require.

There are some supplied procedures, but they are execution based, see
sp_dump_dts***.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org