What about Text Qualifiers? I've never used SSIS and every flat file I've ever worked with has been comma or tab delimited and they utilize double-quotes as text qualifiers.
The reason I ask, using the SSMS import wizard and selecting flat file as the source hasn't worked since 2005 because it completely ignores the text qualifier setting. Now, when I see a GUI interface from MS for data imports, I automatically assume it's going to mishandle this basic need. Does SSIS have this setting and does it work?
EDIT: Actually, reviewing the screenshots, I see it has the setting so now I'm only curious if it works.