Hi I've got two SQL server boxes and I'm importing a flat file.

On a SQL2014 copy importing a flat file delimited with semi colon ; its gets to the end of row and imports a new record.

On the 2008 R2 copy it imports the flat file but when it gets to then end of row it carries on writing to the same row wrapping the data.

Any ideas what I might be doing wrong.

Thanks