SQL Server Performance Forum – Threads Archive
IO error while reading BCP format filehi,
i m having problems with the bcp file format…
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
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
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
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