469,275 Members | 1,773 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

reporting on a DTS performance reporting

Hi all. I have a dts package called package1 that I run once a week
that does some imports/queries against about the same amount of data
each run. I am wondering (hoping!) if I can run a query that will show
its performance over the past 6 months in terms of how long the
execution for each run took.

I think SQL server saves this dts package run history somewhere and if
so how can I do this? Am I totally off base?
Jul 20 '05 #1
1 1179

"sumGirl" <em*****@netscape.net> wrote in message
news:a5**************************@posting.google.c om...
Hi all. I have a dts package called package1 that I run once a week
that does some imports/queries against about the same amount of data
each run. I am wondering (hoping!) if I can run a query that will show
its performance over the past 6 months in terms of how long the
execution for each run took.

I think SQL server saves this dts package run history somewhere and if
so how can I do this? Am I totally off base?


If you scheduled it as a scheduled job, then you can look at the job history
in msdb..sysjobhistory. If you also enabled package logging to MSSQL, you
can check out the msdb..sysdtssteplog table, which has start and end time
columns, as well as elapsed time.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Larry Dooley | last post: by
1 post views Thread by Larry Dooley | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.