Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
BCP unexpected EOF in bcp data-file
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,