SQL Server Performance

IO error while reading BCP format file

Discussion in 'SQL Server DTS-Related Questions' started by cutiepie, Sep 21, 2005.

  1. cutiepie New Member

    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
    cutiepie, Sep 21, 2005
    #2

  2. satya Moderator

    satya, Sep 21, 2005
    #2

  3. dineshasanka Moderator

    dineshasanka, Sep 21, 2005
    #2

  4. cutiepie New Member

    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
    cutiepie, Sep 21, 2005
    #2

Share This Page