Question

  • Creator
    Topic
  • #2148243

    BCP unexpected EOF in bcp data-file

    Locked

    by adam.chiarotto ·

    Hello,

    I’ve been trying to import this data with no luck and this brilliant error message.

    I’m using this command:
    bcp test.dbo.customerdefinition in test.txt -f conf.txt -t -T

    Here is 10 lines from the data-file:
    1 1 BEN ONE BENVENUTO 1 BENVENUTO ST. CLAIR & AVENUE ROAD TORONTO ON
    2 1 BIGGIN DDP PARTNERSHIP 1 BIGGIN LTD. 1 BIGGIN COURT NORTH YORK ON
    3 1 EVA MELIA CORPORATION 1 EVA ROAD SUITE #412 ETOBICOKE ON
    4 1 FINANC CONCERT PROPERTIES 200 BAY STREET- SOUTH TOWER SUITE 2100- PO BOX 56 TORONTO ON
    5 1 LONGBRID BERKLEY PROPERTY MANAGEMENT INC 1 LONGBRIDGE ROAD 2ND FL THORNHILL ON
    6 10 DORA VILLA LASFLORES C/O FOCUS PROPERTIE 10 DORA AVENUE TORONTO- ON
    7 10 HOLMES HALTON COMMUNITY HOUSING 10 HOLMESWAY PLACE ACTON ON
    8 100 CANYON DEL PROPERTY MANAGEMENT 100 CANYON AVENUE BATHURST & SHEPPARD NORTH YORK ON
    9 100 CEDAR LAWRENCE CONSTRUCTION 100 CEDAR AVENUE YONGE & MAJOR MACKENZIE WEST RICHMOND HILL ON
    10 100 GOWAN KANCO – 100 GOWAN LTD. 100 GOWAN AVENUE PAPE & DANFORTH EAST YORK ON
    Here is what the format-file looks like, the table has more columns than this but this is all I have in the data-file:
    9.0
    10
    1 SQLINT 0 4 “” 1 Rowid “”
    2 SQLCHAR 2 15 “” 2 CustomerId SQL_Latin1_General_CP1_CI_AS
    3 SQLCHAR 2 50 “” 3 Name SQL_Latin1_General_CP1_CI_AS
    4 SQLCHAR 2 50 “” 4 Addr1 SQL_Latin1_General_CP1_CI_AS
    5 SQLCHAR 2 50 “” 5 Addr2 SQL_Latin1_General_CP1_CI_AS
    6 SQLCHAR 2 50 “” 6 Addr3 SQL_Latin1_General_CP1_CI_AS
    7 SQLCHAR 2 30 “” 7 City SQL_Latin1_General_CP1_CI_AS
    8 SQLCHAR 2 50 “” 8 State SQL_Latin1_General_CP1_CI_AS
    9 SQLCHAR 2 10 “” 9 Zipcode SQL_Latin1_General_CP1_CI_AS
    10 SQLCHAR 2 50 “” 10 Country SQL_Latin1_General_CP1_CI_AS

    Any help with this is greatly appreciated.
    Thanks,

All Answers

Viewing 0 reply threads