October 23, 2002 at 9:59 pm
hi all,
ok, here i explain my scenario . Actually i created a procedure say usp_bcp_in that is using 'xp_cmdshell' to run bcp. Since i am using Visual FoxPro at Client side i am excuting the above mentioned procedure (usp_bcp_in) using sqlexec. When i run the command i starts bcp as i wriiten in usp_bcp_in. As u must know that when i run bcp on command prompt of server, it displays a batch information above current rows copied, like 1000 default batch size give 1000 rows copied. I want this or some information, importantly ...while bcp is running, to appear at client (Visual fox Pro side) so that my client should at least know that bcp in running and the process has not got stuck! or it has so far copied that much of rows.... So this is where i think i can use trigger to updatte a counter somehow for each row inserted by bcp, i will be able to display the counter on client side. i hope this will explanation will definitly tell u about what i want excatly......
so am waiting eagerly for your comments....
Sabih.
October 24, 2002 at 4:29 pm
A trigger would work...but i think that you could create a stored procedure that executes the bcp command and also calculates the info that you need. Then with a select shows that info and you capture the result of the select from the app.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply