SQLBULKCOPY class - number of records copied

[sb_rkarnati]

Hi,

In one of the tasks, we are using sqlbulkcopy class of .net with three parameters - source db info, destination db info, query to be used to transfer data.

We are trying to see if we can get a count of the number of rows that are actually transmitted by the above command. Is there any way to do that? sqlbulkcopy class does not seem to have any attribute that would give this information. Is there any direct or indirect way?

Thanks in advance
sb

[mendhak]

The sample code for sqlbulkcopy in MSDN shows how to count the rows

http://msdn.microsoft.com/en-us/libr...lbulkcopy.aspx