Monitor Progress of Scheduled DTS Package

[ukflix]

Hi

I have some DTS Packages that I have scheduled. What I would like to be able to do is see the progress of the packages as they are running. Like when you run the package in DTS Design mode, I would like to see the row counts as they update. Anyone got any ideas how I can do this please?

Sean

 

[johnherman]

As a conceptual idea (sorry, no exact code), you could try writing to an audit file every 10,000 (you pick the number) records. There's probably an internal variable for the rows written and you can divide by 10,000 and when the remainder is 0, write out a row to the audit file. You could have each DTS write to the same file or to its own.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright