Question
-
Topic
-
BCP unexpected EOF in bcp data-file
LockedHello,
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 -THere 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_ASAny help with this is greatly appreciated.
Thanks,