Well I see that I am not the only one with this problem. It seems that the Flat File import has problems with commas imbedded into a text field delimited with ". See this post...

http://www.sqlservercentral.com/Forums/Topic1026801-148-1.aspx

Apparently there are more urgent issues to be dealt with regarding SSIS. Interesting, I tried to create a link with the HTML link button in the toolbar but the pseudo-code is being displayed as below at least in the preview pane.

If anyone has solved this problem of SSIS not being able to deal with a comma within a CSV text field, please let me know.

Thanks