IO error while reading BCP format file | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

IO error while reading BCP format file

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 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 thread ?
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
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