How to display progress bar in windows form during execution of DTS package?

[owais]

H

I want to display progress bar during execution of windows form. When I execute DTS package the form will idle till the DTS package finishes

Please help me in this regard. its an urgen

Thank
owais

---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/

[Shiva]

Since the time DTS takes may not be known, you may have a progress bar
similiar to this one:
http://msdn.microsoft.com/msdnmag/is...s/default.aspx
"owais" <[e-mail]> wrote in message
news:eJ**************@TK2MSFTNGP10.phx.gbl...
Hi

I want to display progress bar during execution of windows form. When I
execute DTS package the form will idle till the DTS package finishes.

Please help me in this regard. its an urgent

Thanks
owais

---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/

[Imran Koradia]

I assume you're using the SQL DTS type library. Here's just an idea: One way
would be to have the progressbar based on the records count rather than the
time taken. In the OnStart event of the DTS package, you can retrieve the
tables and the records in each table that you are going to be copying over.
Then, in the OnProgress Event (which will be fired for each record being
copied) you can then update your progress bar either for each record (for a
small number of tables and records) or every so many records depending on
the size of the database being transformed.

hope that helps..
Imran.

"owais" <[e-mail]> wrote in message
news:eJ**************@TK2MSFTNGP10.phx.gbl...

Hi

I want to display progress bar during execution of windows form. When I execute DTS package the form will idle till the DTS package finishes.
Please help me in this regard. its an urgent

Thanks
owais

---
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/