Community

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

Question

Locked

BCP unexpected EOF in bcp data-file

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,

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums