Article ID: 225705 - View products that this article applies to.
This article was previously published under Q225705
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 54077 (SQLBUG_70)
Importing data into SQL Server using the bulk copy program (BCP) may fail if the field terminator is an extended character (that is, ASCII values 128-255). The problem only happens with import files that are over 32 MB in size.
To work around this following, do any one of the following:
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561For more information, contact your primary support provider.
(http://support.microsoft.com/kb/254561/ )INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
This problem has been observed with command line BCP and SQL-DMO BulkCopy.
For example, suppose you have a file called Myfile.txt that is over 32 MB in size. You will encounter this problem if you use the following command-line BCP operation:
bcp pubs.dbo.mytable in myfile.txt -c -t -Usa -P
No data will be imported to pubs.dbo.mytable and results similar to the following will be displayed after a short pause:
0 rows copied.Furthermore, specifying a value for the FirstRow and LastRow properties (-F and -L with command-line BCP) will not avoid this problem.
Network packet size (bytes): 4096
Clock Time (ms.): total 13079
Contact us for more help
Connect with Answer Desk for expert help.