UPDATE: Sorry, I've just checked my source again and it is actually double quoted. So the data in fact looks like this;

123,"xyz","Don't you hate when MS say's it's a ""feature"" and not a bug","more data"

It's not stopping SSIS from failing though. This is such a common thing, I'm sure the answer must be simple, but for now it's illuding me.