Microsoft KB Archive/188327

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.