\r didnt worked getting the same error
The bulk load failed. The column is too long in the data file for row 1, column 11. Verify that the field terminator and row terminator are specified correctly.
Msg 7399, Level 16, State 1, Line 1
i checked in the notepad, and see carriage return characters (instead of new line, i cant see when i open log file in textpad), i dont know how to remove from the logfile (i mean replace carriage return characters with nextline)
Babai
Hi All,
Can someone clue me in on BULK INSERT? I've used it to create a table of one column, and everything worked fine, but now I have a TXT file of about 11 fields. I've tried importing the data by using this as a semicolon-delimited txt(around 400 lines) file
I keep getting several error...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.