I have come across an awkward situation where I have got CSV files with
| as the column delimiter. In these files, I don't have Text column qualifier. (i.e.
My problem is when I am importing these CSV files using
BULK INSERT, if the last column of a row has a line break in it, the text continues into the next row.
I am unable to use SSIS so I am looking for a pure T-SQL solution.
It would be great if someone could guide me in the right direction. I tried reading files using
openrowset but that's not changing anything either.