SQL Server Performance Forum – Threads Archive

IO error while reading BCP format file

hi,
i m having problems with the bcp file format…
9.0
2
1 SQLCHAR 0 4 "," 1 in_numbers SQL_Latin1_General_CP1_CI_AS
2 SQLCHAR 0 5 "
" 2 values SQL_Latin1_General_CP1_CI_AS and the input file is
1234,other
5678,column but now its givin me the error as IO error while reading BCP format file…. it was workin for sometime..it copied these two rows as well…but again its givin me this error again n again…i cant understand…wat m i suppose to do now…PLEASEEEEE TRY TO HELPPPP
thnks in advance

Is this topic related to your current problem threadhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10436 ?
Ensure the path and columns are properly specified for that bcp file. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

check this http://sqlteam.com/forums/topic.asp?TOPIC_ID=43246
—————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka

Hi,thanks for your suggestions….
i found the mistake…it was just after the last row i had to press ENTER twice or thrice so that there will be some more empty rows in the format file…
thats all…n the problem is solved now..
thnks once again

]]>