Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    97

    Unanswered: Bulk Insert Help

    I have a fixed-width flat file that I can't import for the life of me. I've tried SSIS and now bulk insert without avail. Below is the T-SQL I'm using for the BULK INSERT. Can someone please shed some light? Thank you in advance.


    BULK INSERT dbo.TEST_R3_WL20110804
    FROM 'D:\import_files\TEST_R3_WL20110804.txt' WITH
    (
    FIRSTROW = 2,
    FORMATFILE='C:\myFormatFile_TEST_R3.fmt',
    MAXERRORS = 9999999,
    ROWTERMINATOR = '0x0a'
    );

    Returns this:
    Msg 4866, Level 16, State 7, Line 1
    The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.
    Msg 7301, Level 16, State 2, Line 1
    Cannot obtain the required interface ("IID_IColumnsInfo") from OLE DB provider "BULK" for linked server "(null)".

  2. #2
    Join Date
    Oct 2011
    Posts
    29

Tags for this Thread

Posting Permissions

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