If you get this error, it means you are trying to insert data of a length larger than the max length of a data column. For example, you may be inserting “San Francisco” to city varchar(10).
Now, the problem is identify which column is the culprit. I don’t see a way to determine the column from the run time exception.
So you can try 2 other ways:
- Examine each field length of the entity being inserted and compare against the database schema.
- Use SQL Profiler to capture the SQL statement. Then you could examine the length of each insert value. Or you can use the process of elimination by setting each insert value to an empty string until your insert statement executes without error.