BUG: Unhandled AV in BCP Using -e Option and Bad Import Data

ID: Q188327

The information in this article applies to:

Microsoft SQL Server version 6.5

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          : SSrvBCP SSrvGPF kbbug6.50 
Version           : WinNT:6.5
Platform          : winnt 
Issue type        : kbbug

Last Reviewed: April 17, 1999