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,
MAXERRORS = 9999999,
ROWTERMINATOR = '0x0a'
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)".