sql server dts: Hi,

I am looking for the dts run time. Is this information stored anywhere in
the database tables (package name, how many mins etc..) ?

sql 2k, win 2000


Appreciate the responses.

In message <CEF663B2-8051-4E39-B2D1-9DF3A552E060@microsoft.com>,
mark_collings <markcollings@discussions.microsoft.com> writes
[quoted text, click to view]
If you turn on logging to SQL Server in package properties, then yes,
look in msdb sysdtspackagelog, sysdtssteplog and sysdtstasklog tables.


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

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