The last field on each line is followed only by a linefeed \n.
When I try to use bulk insert I get the message that the 40th (last) field on the line is too long.
I have tried adding a tab after the last field but this makes no difference.
I have added an ! (exclamation mark) after the last field and changed the rowterminator attribute to !\n. Still doesn't work?
I am using sftp to copy the file from the unix system to windows, and there is no change in the size of the file, so I don't think that a carrriage return is being inserted.
Any suggestions?
If I reduce the size of the input file to one record, then the insert works.|||Never mind, I figured it out. Lines have to end with '\r\n' regardless of the fact that the documentation says the default ROWTERMINATOR is '\n'
No comments:
Post a Comment