I am getting the following exception when refreshing my database at the end of a test:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: The bulk load failed. The column is too long in the data file for row 1, column 2. Verify that the field terminator and row terminator are specified correctly.
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".
<mytablename>
Checking identity information: current identity value n, current column value '0'.
I am running this against a database on Sql Server 2005 Express with SP2 and am seeing this same identity problem for multiple tables during the refresh.