Results 1 to 2 of 2

Thread: I/O Error reading BCP Format File

  1. #1
    Anthony Merulla Guest

    I/O Error reading BCP Format File

    I added a field to an exisiting table (CHAR 30), and I added to field to the BCP Format File.
    The BCP worked fine before the new field, and still works fine when I exclude the new field
    from the format file, but with the new field I receive the following error:

    SQLState = S1000, NativeError = 0
    Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP format file

    (2 row(s) affected)

    Here is a copy of my format file:
    7.0
    11
    1 SQLCHAR 0 6 "" 1 Empl_ser_no
    2 SQLCHAR 0 2 "" 2 Empl_stat_cd
    3 SQLCHAR 0 1 "" 3 Guest_type_fl
    4 SQLCHAR 0 30 "" 4 Job_tl
    5 SQLCHAR 0 14 "" 5 Pager_no
    6 SQLCHAR 0 1 "" 6 Security_Clear_fl
    7 SQLCHAR 0 9 "" 7 SSN
    8 SQLCHAR 0 30 "" 8 Emer_cont_nm
    9 SQLCHAR 0 14 "" 9 Emer_cont_no
    10 SQLCHAR 0 1 "" 10 Citizen_fl
    11 SQLCHAR 0 30 "
    " 11 Job_Res

    The input file is just a fixed positonal text file, and I have checkid it 100 times- it is fine.

    Any sugestions from any BCP gurus out there? THANKS



  2. #2
    Kurt Shull Guest

    I/O Error reading BCP Format File (reply)

    I hate to say it, but why not just let BCP re-create the format file for you. Keep the old copy (the one you have now that doesn't work) and compare it to the new one. If the new one works, check to see what's different between the two...it might end up saving you time, who knows....


    ------------
    Anthony Merulla at 7/20/00 4:41:57 PM

    I added a field to an exisiting table (CHAR 30), and I added to field to the BCP Format File.
    The BCP worked fine before the new field, and still works fine when I exclude the new field
    from the format file, but with the new field I receive the following error:

    SQLState = S1000, NativeError = 0
    Error = [Microsoft][ODBC SQL Server Driver]I/O error while reading BCP format file

    (2 row(s) affected)

    Here is a copy of my format file:
    7.0
    11
    1 SQLCHAR 0 6 "" 1 Empl_ser_no
    2 SQLCHAR 0 2 "" 2 Empl_stat_cd
    3 SQLCHAR 0 1 "" 3 Guest_type_fl
    4 SQLCHAR 0 30 "" 4 Job_tl
    5 SQLCHAR 0 14 "" 5 Pager_no
    6 SQLCHAR 0 1 "" 6 Security_Clear_fl
    7 SQLCHAR 0 9 "" 7 SSN
    8 SQLCHAR 0 30 "" 8 Emer_cont_nm
    9 SQLCHAR 0 14 "" 9 Emer_cont_no
    10 SQLCHAR 0 1 "" 10 Citizen_fl
    11 SQLCHAR 0 30 "
    " 11 Job_Res

    The input file is just a fixed positonal text file, and I have checkid it 100 times- it is fine.

    Any sugestions from any BCP gurus out there? THANKS



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •