Track and display the progress of a DTS package?

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
 
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
 
R

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.
 
R

Rich Wallace

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.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Executing a DTS package 2
How to display progress bar in windows form during execution of DTS package? 4
How to display progress bar in windows form during execution of DTS package? 1
How do I capture DTS OnProgress events from Execute Package tasks? 2
Permission required to execute a DTS package from ASP.NET app 2
DTS pkg VB6 to VB.Net problems - Sql Srv2000 1
Executing a DTS Package from Access 2003 (Visual Basic) 2
Progress bars and Track bars. 1

Top