We've had all kinds of trouble with text delimiters when importing to SQL2005. From our past experience if the text delimiter is in the column it just needs to be doubled up - but SSIS and import wizard trip up on it. After googling around we discovered it is a known bug or feature <grin>. And our understanding is that this has NOT been changed in SQL2008.

We do not allowed import files to be sent to us with text qualifiers anymore. We usually have OK luck with a multi-character column delimiter like #~

others have discovered the same issue...

http://www.sqlmag.com/community/Forums/tabid/426/aff/80/aft/69713/afv/topic/Default.aspx

not sure if this is your problem, but beware of those text delimiters in SQL2005 or SQL2008...

jg