sql server dts: I have designed a DTS package and have enabled SQL Server logging in
the properties of the DTS package. Since this is writing to the msdb,
does it just keep on writing? How do I specify how long I want to keep
the logging information around in the msdb?

Thanks,
Kayda

I dont remember there is option to specify how often you want the log being
purged during design time. However you can aways schedule a job to delete
record from msdb..sysdtspackagelog, sysdtssteplog and sysdtstasklog.



[quoted text, click to view]