Unanswered: BCP in failed! urgent help needed
I am having a small problem with bcp in a text file.
I am parsing an excel file using perl modules, storing the dta in a text file and tht data needs to be bcp in into a table in a database. now i have done bcp before but earlier i was doing bcp out and then bcp in the result file of bcp in so no interaction with the text file was needed.
Now since the text file has been created external to the bcp operation it is giving me the following error and I ant figure it out
Unexpected EOF encountered in BCP data-file
bcp copy in failed
Can't spawn "bcp dbo.tablename in file.txt -S abc -U sa -P xxx -c": No error at perlscript.pl line 104.
If anyone can help me as to what the problem may be it'll be great!
I was wondering if the problem is because you can only bcp in a file tht is theresult of a bcp out? Or maybe becoz any bcp in file has some special characteristic that specifies and EOF or something?
Please help asap..thnx in advance
You try and try again..but then give up, there's no sense in being a complete fool about it!!!