BUG: When You BCP More Than 117 Columns an Access Violation Occurs (280735)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q280735
BUG #: 351079 (SQLBUG_2000)

SYMPTOMS

If you attempt to bulk copy in more than 117 columns of data from a text file while using a format file, the bcp utility may cause an access violation. The error message that occurs is:
The instruction at "0x006c0061" referenced memory at "0x006c0061". The memory could not be "read".

WORKAROUND

To work around this problem either:
  • Use Data Transformation Services (DTS).

    -or-

  • Use a BULK INSERT if the format file is required.

REFERENCES

For the full syntax of the BULK INSERT command, see the "BULK INSERT" topic in Microsoft SQL Server Books Online.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB280735
©2003 Microsoft Corporation. All rights reserved.