FIX: BULK INSERT Fails when FIRSTROW is Greater Than 1 for Text That Contains Data (201834)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 7/19/2006 |
|---|
| Keywords: | kbBug kbfix KB201834 |
|---|
|