BUG: Unhandled AV in BCP Using -e Option and Bad Import Data
Article ID: 188327
Article Last Modified on 3/2/2005
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q188327
BUG #: 17953 (SQLBUG_65)
SYMPTOMS
An unhandled access violation can occur when using the bulk copy program
(BCP) to copy data into a table if both of the following conditions are
met:
- The input file has smalldatetime columns that are outside the
allowable range of values.
-and-
- The -e option is used to specify an output error file of rows
not copied.
Rows will be inserted until BCP encounters a batch with bad data. No rows
in the batch with the errors will be inserted. The BCP operation will
stop with the following messages:
DB-LIBRARY error:
Attempt to convert data stopped by syntax error in source field.
DB-LIBRARY error:
Data-conversion resulted in overflow.
WORKAROUND
You can work around the problem by either not using the -e option or by
correcting the incorrect data (ensure that the columns are within the
allowable range of values).
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
We are researching this problem and will post new information here in the
Microsoft Knowledge Base as it becomes available.
Additional query words: prodsql
Keywords: kbbug kbpending KB188327