Why do regex style line endings no longer work with bulk insert but hex style does?

30 Views Asked by At

I know there are plenty of examples out there about using 0x0a for ‘ROWTERMINATOR’ but I don’t understand why that is needed. When verifying my files I can see in NP++ that they have either windows or Linux style line endings and can assist accordingly, but that doesn’t seem to work anymore. I’m now forced to use 0x0a and 0x0d. There’s no mention of any changes that I’ve found, but clearly something is different. I’m on 2022 CU10 if it matters.

——

ETA: By regex style line endings I mean \r , \n and \r\n.

0

There are 0 best solutions below