Results 1 to 2 of 2

Thread: Bulk Insert

  1. #1
    Join Date
    Oct 2006

    Unanswered: Bulk Insert

    I have a problem with bulk insert importation. I have a txt file with 3400 columns and 1 table with two fields.

    data - varchar(5000)
    id - numeric (identity yes - 1)

    when I import the file the system return this error message:

    Bulk Insert fails. Column is too long in the data file for row 1, column 1. Make sure the field terminator and row terminator are specified correctly.

    my bulk insert sintaxe is:

    BULK INSERT eflex.dbo.Import_Data
    FROM 'C:\HP\HP_Receive\FBSJ01D5.txt'

    can anybody help-me?


  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    1. What is your row terminator?
    2. Maybe the data row exceeds your definition.
    3-n any number of data or schema errors

    Try this ... create a input table with 1 column defined as varchar(8000), then bcp in the file. You can then use SQL Server to inspect column lengths, and even parse the data into your working table.

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts