BUG: Error 7399 When You Bulk Insert into Table with Column Default on a NUMERIC or DECIMAL Column

Article translations Article translations
Article ID: 272292 - View products that this article applies to.
This article was previously published under Q272292
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 58317 (SQLBUG_70)
Expand all | Collapse all

Symptoms

When you attempt to BULK INSERT into a table with a column default on a NUMERIC or DECIMAL column, the process will fail with the following error message:
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.

Workaround

Use Bulk Copy Program (BCP) instead.

Status

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

Properties

Article ID: 272292 - Last Review: November 2, 2013 - Revision: 2.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbdsupport KB272292

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com