FIX: BCP IN w/ Format File Into NUMERIC/DECIMAL Column Fails |
Q142451
On SQL Server 6.0, BCP into a NUMERIC/DECIMAL datatype column will fail if a format file is used.
Use BCP without the format file, this works fine. You can also use character mode or native mode BCP.
Microsoft has confirmed this to be a problem in Microsoft SQL Server Version 6.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.0. For more information, contact your primary support provider.
BCP IN into a table with NUMERIC/DECIMAL datatype column, using a format
file, will fail with the following error:
DB-LIBRARY error:
Attempt to read unknown version of BCP format file.
Command has been aborted.
Additional query words: sql6 winnt bcp
Keywords : kbusage
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: March 25, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |