I am looking for a simple way to find out when a DTS was last time
executed. We do have hunderts of DTS on our SQL2k servers and want to
get ride of the not used DTS before we migrate to SQL05. Some of these
DTS may run only every 3 month (Quaterly end), some only every month
once (Month end) other every day and some never...

The only way I know to get the information I need is to trace. But I
still hope there is a table in the master DB where SQL logs all
executed DTS or something else which will avoid a 3 month trace.

On 1 Sep., 15:10, Marty <martin-za.fr...@ubs.com> wrote:
> I am looking for a simple way to find out when a DTS was last time
> executed. We do have hunderts of DTS on our SQL2k servers and want to
> get ride of the not used DTS before we migrate to SQL05. Some of these
> DTS may run only every 3 month (Quaterly end), some only every month
> once (Month end) other every day and some never...
>
> The only way I know to get the information I need is to trace. But I
> still hope there is a table in the master DB where SQL logs all
> executed DTS or something else which will avoid a 3 month trace.

from what i know is, that the logging is not default. you have to set
parameters for logging.
the standard is: open your dts package, left mouse click, logging.
here you can allow logging set parameters for logging.
the standard logging you will than find in the msdb database, table
sysdtspackagelog.
if you need more logging you can:
-write into txt logfiles
-insert some sql tasks in your dts packages, which write in self
defined log tables
-set some parametes in dtsrun command
....

kr moby