This might be a noob question, but is there any way to specify just <lf> as a line delimiter, and not <cr><lf> (/n) as line delimiter in T-SQL call for BULK INSERT (or BCP utility). How please TIA.

Re: BCP (BULK INSERT) with only <lf> as line delimiter (not <cr><lf>)...


Usually any of these three combination would work for all kinds of files.


You might try /r first, I think that's the one you need if /n doesnt' work.