2012年3月6日星期二

BCp ERROR?

Getting the following error when loading txt file to a table
All rows appear to be loaded

What can be done to avoid this error?

Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file

bcp "table" in "textfile" -f"Format.fmt" -e"error.txt" -SServername -Tis that the entire contents of the error.txt file? Usually the error file will tell you what row/column had the problem.

没有评论:

发表评论