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 |
|
PrasannaNew
Starting Member
1 Post |
 Posted - 2004-09-22 : 14:56:48
|
| Hi All, I am updating a bulk of records into the first two columns of a table using BCP-IN.The data file is created using a java code which gets the data from the LDAP and stores in CSV format.bcp databasename.table in "mydatafile.csv" -u "admin"- S "my host" -P "password" -w I tired this many times only to get EOF exception.Please tell what could be the problem with this. If somebody could help asap it would be great.I tired storing the data from LDAP as xls, also but i get a Sting Data, Right Truncation. As this is gona be a automated process.LDAP->CSV or XLS ->DB. I dont know what is wrong with bcp or my input data file.Thanks a lot in advance,Prasanna |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-09-22 : 17:31:53
|
| -w?What are your field terminators? If it is comma separated try -w -t,Also look at the file - excel often puts some blank lines at the end.Try just bcping in the first line.I prefer bulk insert to bcp, it shouldn't matter too much but it handles a few things bcp doesn't.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
BCP-IN Error