By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
439,971 Members | 1,732 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 439,971 IT Pros & Developers. It's quick & easy.

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

P: n/a
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/
Jul 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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" <sohail29@-NOSPAM-hotmail.com> 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/
Jul 21 '05 #2

P: n/a
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" <sohail29@-NOSPAM-hotmail.com> 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/

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.