PDA

View Full Version : show progress of transfer text



mpearce
06-12-2009, 10:43 AM
How can i have a progress bar or something like that show the progress of a transfertext statement?

I have 2 text files that get imported to a table using transfertext statements and i would like to have a progress bar show the progress of the import so that the end user doesnt think the application is hanging on them.

I cannot figure out how to do this. I looked into syscmd's initmeter function but i dont know how to implement that or apply it to a transfertext statement.

Any ideas?

orange
06-22-2009, 03:26 PM
Here's a link that may help

http://support.microsoft.com/?kbid=304581

Good luck

mpearce
06-23-2009, 11:33 AM
that is helpful. But isnt that just showing a progress bar as it reads back data that is already in a table?? I would need something that would show what transfer text is processing and update that regularly, ex. record by record.

Basically the reason I am trying to do this is, is so the user doesn't think the application is hanging. The files I am importing can be pretty big.

Is this possible? Or am I crazy? lol