kingdonshel (8/3/2015)
Thanks Phil for highlighting where I initially pointed out that the comments column is already in double quotes, I think the supplier of the flat file has already done the right thing by adding the double quotes infact there are tripple quotes at times, and I think I have read that text with double quotes should treat all characters as literal text. So I don't know why I get this problem, I have to be checking the file daily and backspacing out the CRLF before the SQL Server Agent job that runs the file kicks off.
Have you actually setup the job to use the double quote as a text qualifier?
--Jeff Moden
Change is inevitable... Change for the better is not.