Home Forums SQL Server 2008 SQL Server 2008 - General BCP command to import data from txt file (Pipe as Field terminator)into SQL Table. RE: BCP command to import data from txt file (Pipe as Field terminator)into SQL Table.

  • SQLState = S1000, NativeError = 0

    Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in

    BCP data-file

    0 rows copied.

    I got this Error.

    I even added the "format file".

    I have 3 columns in the Table. No Identtity Column. and No PK's

    CREATE TABLE dbo.Cust

    (Sno INT,

    Name Varchar(20),

    Location Varchar(30)

    )

    And the .txt file has 3 columns... with Pipe delimited.

    Ex:

    1|Cust1|Newyook

    2|John|Washington

    100|Alan|Seattle