Thanks, Pablo.

This is not a customer-facing system. Its just R&D, but you are right about them getting their bowels in an uproar.

How about TMA

Too Many Acronyms.

I still like LSMFT.

Thanks for the response.

Another trick I came across is to tweek the Hkey_Local_Machine,Software, Microsoft, Microsoft SQL Server,80,MSSQLLicenseInfo,MSSQL8.00,Mode key. Change it to 0 and the licensing thingy on the Control...

I added MAXERRORS=0 to the WITH clause and ran it again. This is what I get:

-----------------------------------------------------

Server: Msg 4863, Level 16, State 1, Line 1

Bulk insert data conversion error (truncation)...