BULK INSERT导入.dat文件失败，行分隔符问题求助

我在编写BULK INSERT脚本导入.dat文件时多次报错，已确定问题与行分隔符相关：

• 使用SQL导入向导时，采用默认行分隔符{CR}{LF}、列分隔符逗号{,}，可成功导入50万行158列的数据
• 自行编写脚本时，尝试过\r\n、0x0a等多种行分隔符，单条数据能成功导入，但导入两条数据时就会出错：
  • 使用\r\n时错误最少，报错信息为：

    Msg 4863, Level 16, State 1, Line 3 Bulk load data conversion error (truncation) for row 1, column 158 (Column 157)

  • 使用0x0a时错误数量更多

.dat文件内容如下：

xxx,20080501,xxx,xxx:175000,55008654,0178636,202307011001,001859915,OK,W,xx,1.0,00000100,48,202306290100,R0,2,202306290200,R0,0,202306290300,R0,0,202306290400,R0,0,202306290500,R0,1,202306290600,R0,1,202306290700,R0,0,202306290800,R0,0,202306290900,R0,0,202306291000,R0,0,202306291100,R0,0,202306291200,R0,1,202306291300,R0,0,202306291400,R0,0,202306291500,R0,2,202306291600,R0,1,202306291700,R0,0,202306291800,R0,0,202306291900,R0,0,202306292000,R0,0,202306292100,R0,0,202306292200,R0,0,202306292300,R0,2,202306300000,R0,3,202306300100,R0,0,202306300200,R0,0,202306300300,R0,2,202306300400,R0,0,202306300500,R0,1,202306300600,R0,1,202306300700,R0,3,202306300800,R0,0,202306300900,R0,0,202306301000,R0,0,202306301100,R0,0,202306301200,R0,3,202306301300,R0,1,202306301400,R0,0,202306301500,R0,1,202306301600,R0,1,202306301700,R0,0,202306301800,R0,0,202306301900,R0,1,202306302000,R0,0,202306302100,R0,1,202306302200,R0,0,202306302300,R0,1,202307010000,R0,0
xxx,20080501,xxx,xxx:175000,55008654,0178636,202307011001,001859915,OK,W,xx,1.0,00000100,4,202307010100,R0,1,202307010200,R0,0,202307010300,R0,1,202307010400,R0,0

内容的提问来源于stack exchange，提问作者DASA