Move the cursor to the end of the file. 3. Not sure if there is a BCP option to remove. –Jon Raynor Dec 18 '13 at 17:38 Thanks for the answer.! Powered by vBulletinCopyright ©2000 - 2016, Jelsoft Enterprises Ltd.Forum Answers by - Gio~Logist - Vbulletin Solutions & Services Home Register New Posts Advertising Archive Privacy Statement Sitemap Top Hosting and Cloud Copyright © 2002-2016 Simple Talk Publishing. have a peek here
You cannot edit other topics. Inside the format file i have omitted the identity column. You cannot post topic replies. The time now is 12:40 PM. http://stackoverflow.com/questions/9948130/i-o-error-while-reading-bcp-format-file
One syllable antonym for "care"? dbforums Yak CorralRadio 'Rita dbForums Member List I'm Good Once as I ever was The physical order of data in a database has no meaning. Hi, i wanted to ask on the same context of bcp...i m trying to insert two rows into a table using the bcp command prompt and the bcp file looks as You cannot upload attachments.
Advertisement dBforums Brief Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors Top Helpers healdem - 59 mark.b - 55 Pat Phelan - 54 ranman256 - 23 Proof of non-regularity, based on the Kolmogorov complexity Make an ASCII bat fly around an ASCII moon My fears and resentment about my supervisor Why are there so many stock exchanges You cannot delete other topics. and Inside the data file also i do not have anything corresponding to identity column..
You cannot post HTML code. Error = [microsoft][sql Server Native Client 10.0]i/o Error While Reading Bcp Format File I've indicated the extra line with a red rectangle. With my suspicions aroused, I used a binary file viewer to look at the contents of each file and highlight the differences. dig this Cause An error occurred in reading the bcp input file.
Forgot your password? We've restricted the ability to create new threads on these forums. The answer was so quirky/obscure that I think it may help others. You cannot send private messages.
If this is your first visit, be sure to check out the FAQ by clicking the link above. navigate here Not the answer you're looking for? Total sent: 80000 1000 rows sent to SQL Server. Total sent: 78000 1000 rows sent to SQL Server.
Even if you don't have a complete answer, the original poster will appreciate any thoughts you have! For SQL 2k it.s8.0 I guess 2005, it should be 9.0, but I don't know that for sure. you are a lifesaver. Check This Out Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New?
You cannot edit your own events. Heisenberg's Uncertainty Principle Why don't we have helicopter airlines? Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new
Results 1 to 2 of 2 Thread: [mssql] I/O error while reading BCP format file Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode I used BCP to create a format file for me (which looked identical to the format file that I created) and it worked fine. Report Abuse. this contact form sql-server-2008-r2 bcp share|improve this question edited Mar 30 '12 at 18:07 asked Mar 30 '12 at 17:59 Jon Raynor 2,6641130 add a comment| 1 Answer 1 active oldest votes up vote