When you use BCP then you would definelty get to see this error "Unexpected EOF encountered in BCP data-file". Not only that I have seen this as one of the frequently asked questions (FAQs) and for a moment you might be thinking why there is an end of file. So better to check the match between the source file columns that are imported and the fileds in the destination table in SQL Server, you might be stumped due to the Identity column which will be the first column on that table. As usual BCP process...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/08/28/error-microsoft-odbc-sql-server-driver-unexpected-eof-encountered-in-bcp-data-file.aspx