bulk insert ... from '...' with (fieldterminator = ',', rowterminator = ', \ n') --Remove the spaces between , \ n

Need to ensure that there is a carrage return at the end of the last line in the file

1,2,3,(CR)

4,5,6,(CR)

7,8,9,(CR)