SEO

#1 (**permalink**) 02-29-2008, 04:27 AM

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?

#2 (**permalink**) 02-29-2008, 04:27 AM

"sumGirl" <emebohw@netscape.net> wrote in message
news:a5e13cff.0410050512.37245b7a@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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

reporting on a DTS performance reporting