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 |
|
chicks2001
Starting Member
15 Posts |
 Posted - 2003-04-10 : 08:35:47
|
| I am receiving the following error message after my files are copied.Unexpected EOF Encountered inBCP Data FileThe it will say that my 10 files have been copied and when I check indeed they have.The following is the code I am using for a comma delimited flat file.bcp dbname.dbo.tablename IN C:\temp\file.txt -Uusername -Ppwd _Ssevername -t "," -cPlease advise |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-04-10 : 08:49:18
|
| Check the end of file is with \n. (ie..enter). I have also faced the same problem once. After giving enter at the end of the file the problem disappered.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
chicks2001
Starting Member
15 Posts |
Posted - 2003-04-10 : 08:53:30
|
Thanks I will give that a shot. I just need to place that in my Txt File correct?  |
|
|
|
|
|
|
BCP Import/Export