Microsoft KB Archive/112003

{|
 * width="100%"|

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

 * }

Q112003

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2x

-

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

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2