Ken,

1) select count(*) from the destination table periodically

2) you might be able to read the bcp log file at the bottom of the file will be the number of records processed. For example here is part of a log:

Batch successfully bulk-copied to SQL Server.
10000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
20000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
30000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
40000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
50000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
60000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
70000 rows sent to SQL Server.
Batch successfully bulk-copied to SQL Server.
80000 rows sent to SQL Server.

You'll have to make sure you use a file read that does not exclusively lock the file and that SQL will let you read the file while it is writing it.


>I want to measure the progress of a bulk-copy event from within a VFP application, with a thermometer control. Setting up the control is easy. Starting the bcp is easy to. But, is there a way to get the status of the bcp event from the SQL server while it is running and not just after the fact? Status in this case means, how many records have been processed so far.