
June 23rd, 2005, 09:45 AM
|
|
Registered User
|
|
Join Date: Jun 2005
Posts: 1
Time spent in forums: 12 m
Reputation Power: 0
|
|
|
Error reported during BCP load
Hi, I am trying to load some records using BCP command in to a table. Following is the command that I use.
bcp usertemp in userdata.txt -C932 -fuser.fmt -SmyServerName -UmyUserName -PmyUserPW
The above always gives me 'Unexpected EOF encountered in BCP data-file'. Giving the codepage # as my data file has Japanese characters in one of the fields.
But the same data file just gets loaded fine via DTS. Questions are
(1) Any idea as to why do I receive the above mentioned error?
(2) Can I kick off DTS from command prompt? If so, how?
Thanks!
Last edited by meena_senthil : June 23rd, 2005 at 09:46 AM.
Reason: Would like to give more information.
|