Track and display the progress of a DTS package?

  • Thread starter Thread starter Rich Wallace
  • Start date Start date
R

Rich Wallace

Hi all,

I'm writing a simple SQL Server DTS management VB.NET web app for our first level support group. I'm adding in the capability to execute a package but I was curious if there was a way to track the progress of the package once it's running and display the progress via progress bars and step executution text? Does anybody have any examples or ideas on how to accomplish this?

TIA
-Rich
 
Hi all,

I'm writing a simple SQL Server DTS management VB.NET web app for our first
level support group. I'm adding in the capability to execute a package but
I was curious if there was a way to track the progress of the package once
it's running and display the progress via progress bars and step executution
text? Does anybody have any examples or ideas on how to accomplish this?

TIA
-Rich
 
You could try reading the DTS log directly from SQL Server. It updates
itself in realtime as each step is completed. That is, if you have logging
enabled.
 
Thanks for the hint Rich, I appreciate it.

Rich said:
You could try reading the DTS log directly from SQL Server. It updates
itself in realtime as each step is completed. That is, if you have logging
enabled.
 
Back
Top