Microsoft KB Archive/280735

= BUG: When You BCP More Than 117 Columns an Access Violation Occurs =

Article ID: 280735

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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 &quot;0x006c0061&quot; referenced memory at &quot;0x006c0061&quot;. The memory could not be &quot;read&quot;.



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

-or-


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

STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.

Additional query words: Dr. Watson bcp.exe has generated errors

Keywords: kbbug kbpending KB280735

-

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

© Microsoft Corporation. All rights reserved.