Microsoft KB Archive/201834

= FIX: BULK INSERT Fails when FIRSTROW is Greater Than 1 for Text That Contains Data =

Article ID: 201834

Article Last Modified on 7/19/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q201834



BUG #: 53030 (SQLBUG_70)



SYMPTOMS
The following error message may occur when you try to use the BULK INSERT statement to import data into a SQL Server table that has text datatype columns and the BULK INSERT specifies a Firstrow > 1:

Server: Msg 4866, Level 17, State 66, Line 0

Could not bulk insert because column too long in data file. Make sure FieldTerminator and RowTerminator were specified correctly.



WORKAROUND
To work around this problem, use this instead: xp_cmdshell 'BCP......-Fx'



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack SP1 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:

http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspx

For more information, contact your primary support provider.

Additional query words: text 4866 bcp bulk insert

Keywords: kbbug kbfix KB201834

-

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

© Microsoft Corporation. All rights reserved.