How do I get the number of rows affected by a BULK INSERT on SQL Server?

Question

How do I get the number of rows affected by a BULK INSERT on SQL Server (2008 if that matters)?

Answer 1

Have you tried examining @@ROWCOUNT ?

(Note: you need to set a variable = @@ROWCOUNT before executing any other statement, otherwise its value will be reset)

Answer 2

Be careful if any triggers fire as a result of your BULK INSERT, as this may affect your result.