sql server dts: hi,

i have to use a progress bar in vb.net to indicate the performance of
dts package execution. For this purpose, the interval property of timer
has to be set to the execution time of package, so how can i retrieve
the execution time of dts package at runtime in VB.net.

OR

if some1 has any idea other than using timer for progress bar then plz
tell me.

thanks.

It may be too difficult to determine how close your DTS package is to being
complete. If that's the case, you can try incrementing the progress bar
until it gets to 100% and then set the progress bar to 0% creating a loop
until the DTS package finishes. You could also use an animated graphic to
represent DTS package activity kind of like the image Windows XP uses at
startup. Hope this helps!

[quoted text, click to view]