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

ID: Q188327


The information in this article applies to:

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:

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