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 |
|
Rach2009
Starting Member
37 Posts |
 Posted - 2009-10-22 : 06:15:05
|
| Hi,I am currently trying to create a format file using bcp, when I get to the point when I am asked do I want to save this format information in the file I select Y and then select a Host filename (orders.fmt) but keep getting the following error message back:-"Starting copy...SQLState=HY000, Native Error=0Error=[Microsoft][SQL Native Client]Unexpected EOF Encountered in BCP data file 0 rows copied."Any ideas why it is not saving the format file? Also, I am inputting "/",\"" for all the field terminators (except the last one which I out as "\"\n") as I am trying to accomodate quotes in the original file - is this the correct notation? Or should I leave out the \.Thanks!! |
|
|
|
|
|
Creating a format file in bcp-error in saving