BUG: BULK INSERT Fails with Error Message 7399 (324122)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q324122
BUG #: 58262 (sqlbug_70)

SYMPTOMS

A BULK INSERT operation may fail with error message 7399 if the size of the input file is 65536 bytes or a multiple of 65536 bytes (for example, 3473408 bytes).

The error message that you receive is:
Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. The statement has been terminated.
Additionally, you may receive this error message:
Server: Msg 4866, Level 17, State 66, Line 1 Could not bulk insert because column too long in data file. Make sure FieldTerminator and RowTerminator were specified correctly.
NOTE: You can receive error message 7399 in other situations. Make sure that your conditions match the symptoms in this article.

WORKAROUND

To work around this problem you can either:
  • Use the bcp utility. The bcp utility works with both character and native file types.

    -or-

  • Use Data Transformation Services (DTS).

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

If you set trace flag 7300 on with the DBCC TRACEON (7300) command, you can see additional information, such as this error message:
OLE DB error trace [OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005: The provider did not give any information about the error.]. Msg 7399, Level 16, State 1, Server server name, Line 1
OLE DB provider 'STREAM' reported an error. The provider did not give any information about the error. The statement has been terminated.
The server name in the error message refers to your specific environment.
Modification Type:MajorLast Reviewed:7/22/2002
Keywords:kbbug KB324122
©2002 Microsoft Corporation. All rights reserved.