I realize this is a very old tip, but I've been searching endlessly for a solution to my problem.
How do you deal with embedded text qualifiers in SSIS? I know that DTS dealt with this stuff correctly and I can't for the life of me figure out how to make SSIS read the file correctly. For example:
"This is field1","This is ""field2"""
In DTS if you selected " as your text qualifier it would correctly give you the following:
This is field1, This is "field2"
In SSIS it just breaks. Any help is greatly appreciated.