Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-20 : 08:17:25
|
| Jan writes "Hi. We are running a bulk insert from within a stored procedure.Maxerror is set to 1 (although various values for this have been tried). The primary (only) error that we encounter inside the import files is an overly long value destined for a specific varchar field. Bulk insert does not however raise an error when it encounters such a field value. It simply truncates the additional characters in the field and inserts the record as though there is no problem.1) Is there a way to force bulk insert to raise an error when it encounters an overly long data value amongst a number of other good records?2) Is there a setting to stop truncation of long field values. ie. Raise an error instead? Thanks." |
|
|
|
|
|
Bulk Insert Field Truncation