BULK INSERT LF Rowterminator

[njvsummit]

I have a UNIX file that I am trying to BULK INSERT, but can't seem to get the correct rowterminator. Each row ends with a LF and I have tried \r, \n, and \r\n, but all return in error. If I replace the LF with CRLF, then it works with '\n', but this is going to be a daily process with some large files and I would like to avoid that step if possible.

Thanks

 

[flaniganmj]

I have also recently run into this problem. Were you able to find a solution?

mf