Hello.
Does a DTS package internally store the last time it was executed?
I'd like to generate a report of those that haven't been executed in over 6
months.

You can enable logging to a file or table, from the package properties
dialog box. If the packages are scheduled as jobs, then you can check the
job history.

I don't think DTS will keep any execution history, without you asking for
it.

You can also have a step at the beginning of a package to log an entry in a
table.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Jeff F" <someone (AT) somewhere (DOT) com> wrote