Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
devisetti
Starting Member
30 Posts |
 Posted - 2008-10-08 : 06:55:02
|
| Iam doing BCP and getting follwoing error.I have tried but no luckError = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-fileMany thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-08 : 06:57:14
|
| http://sqlserver-qa.net/blogs/tools/archive/2007/08/28/error-microsoft-odbc-sql-server-driver-unexpected-eof-encountered-in-bcp-data-file.aspx |
 |
|
|
devisetti
Starting Member
30 Posts |
Posted - 2008-10-08 : 07:07:51
|
| thanks but i have created a format file for fixed length.The last filed in the destination table is a date filed ehcih is defaulted to sysdate when created the tabel. Do I need to mention this as well in the fmt file.9.0271 SQLCHAR 0 6 "" 1 SORT_CODE ""2 SQLCHAR 0 8 "" 2 ACCOUNT_NO ""3 SQLCHAR 0 15 "" 3 CUSTOMER_ID ""4 SQLCHAR 0 12 "" 4 ROLL_NO ""5 SQLCHAR 0 4 "" 5 CURR_BRANCH ""6 SQLCHAR 0 4 "" 6 PREV_BRANCH ""7 SQLCHAR 0 4 "" 7 BRAND ""8 SQLCHAR 0 1 "" 8 ACCT_STATUS ""9 SQLCHAR 0 1 "" 9 DORMANT_FLAG ""10 SQLCHAR 0 3 "" 10 ACCT_HOLD_TYP_CODE ""11 SQLCHAR 0 10 "" 11 ACCT_OPEN_DATE ""12 SQLCHAR 0 10 "" 12 ACCT_CLOSE_DATE ""13 SQLCHAR 0 1 "" 13 CLOSURE_REASON ""14 SQLCHAR 0 1 "" 14 TRI_CODE ""15 SQLCHAR 0 1 "" 15 MULTI_TRI_FLAG ""16 SQLCHAR 0 80 "" 16 ADDR_LINE_1 ""17 SQLCHAR 0 40 "" 17 ADDR_LINE_2 ""18 SQLCHAR 0 40 "" 18 ADDR_LINE_3 ""19 SQLCHAR 0 40 "" 19 ADDR_LINE_4 ""20 SQLCHAR 0 40 "" 20 ADDR_LINE_5 ""21 SQLCHAR 0 40 "" 21 ADDR_LINE_6 ""22 SQLCHAR 0 10 "" 22 CURR_PROD_CODE ""23 SQLCHAR 0 10 "" 23 PROD_EFF_DATE ""24 SQLCHAR 0 1 "" 24 TRANSACTION_FLAG ""25 SQLCHAR 0 1 "" 25 CHG_OF_OWNERSHIP_FLAG ""26 SQLCHAR 0 1 "" 26 PROD_HIST_FLAG ""27 SQLCHAR 0 1 "\r\n" 27 ADDT_ACCT_HOLDER_FLAG "" |
|
|
|
|
|
|
Error = [Microsoft][SQL Native Client]Unexpected E