INF: Native Mode BCP to Mis-Defined Table Loads Incorrectly

Last reviewed: April 29, 1997
Article ID: Q112003

The information in this article applies to:

  - Microsoft SQL Server version 4.2 for OS/2
  - Microsoft SQL Server version 4.21

SUMMARY

Using native mode bulk copy to load data in a mis-defined table can cause the table to be loaded incorrectly. The incorrect loading might appear as an unusual formatting of data in the target table. This would also apply to client tools which use the BCP API in native mode, such as SQL Object Manager.

MORE INFORMATION

Native mode bulk copy is intended for high-speed data transfer between identically defined tables. To achieve the optimum transfer rate, there are few checks performed regarding data formatting. The user must ensure the table is correctly defined or else use character-mode bulk copy. Correct table definition includes the correct number of columns, datatype, length, and NULL status.

Additional query words: BCP Windows NT
Keywords : kbtool SSrvBCP SSrvWinNT
Version : 4.2 | 4.21
Platform : OS/2 WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 29, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.