Does anyone know of a good workaround for this known bug in SSIS where the flat file connection manager can't deal with embedded quotes in a comma seperated file i.e SSIS can't correctly parse a file like 

"ABC","DEF",""Hello world, again""

Apparantly this was ok in DTS and I know for a fact this is imported perfectly by the Microsoft Access import wizard and the Excel importer.

Talk about inconsistency!

Patrick