I ran SQL Server 2005's bulk copy program BCP like this:
bcp mydb.dbo.mytbl in myfile.blk -c -S mysvr -U mylogin -P mypass
And it ran and produced output like so:
Starting copy... 1000 rows sent to SQL Server. Total sent: 1000 ... 1000 rows sent to SQL Server. Total sent: 55000
But then it stopped. The cursor did not return to prompt, I haven't received the "... rows copied." message.
I tried querying the target table and I can already see the rows that I wanted to import.
Shall I terminate the console? Will it rollback?