dbTalk Databases Forums  

how to retreive execution time in vb.net

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss how to retreive execution time in vb.net in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
san
 
Posts: n/a

Default how to retreive execution time in vb.net - 07-06-2006 , 02:45 AM






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.


Reply With Quote
  #2  
Old   
Matt
 
Posts: n/a

Default RE: how to retreive execution time in vb.net - 07-08-2006 , 09:48 PM






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!

"san" wrote:

Quote:
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.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.