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:
For more information, contact your primary support provider.
Additional query words: text 4866 bcp bulk insert
Keywords: kbbug kbfix KB201834