Import file: between 90 list a Txt file is to use TAB TAB delimited
150000 rows of data
Bulk insert from ABC 'E: \ 123. TXT'
With (FIELDTERMINATOR='\ t'
ROWTERMINATOR='/n',
FIRSTROW=1)
Using bulk Insert method always prompt large capacity load failure when importing data, data files in the lines of the first X 1 column is too long, please verify whether it is right to specify the field terminator and line terminators
I checked the line terminators for CRLF text file may be NULL values,
Could it be the NULL values lead to? How to batch to remove the NULL values?
CodePudding user response:
Error message to the following
Message 4866, level 16, state 1, line 1
Large capacity load, failure data files in line 1 92th column is too long, please verify whether it is right to specify the field terminator and line terminators,
Message 7399, level 16, state 1, line 1
Link to the server "(null)" OLE DB access interface "BULK" error, the provider did not give any information about the error,
Message 7330, level 16, state 2, line 1
Can't from the link server "(null)" OLE DB access interface "BULK" line extraction,