this is a clarification to my msg above, in the currency fields where there is a comma, the column gets split. for example:

"6,838.65"

will be split to "6 and 838.65"

this caused...

this could be. how should I fix that? I open the flat file in excel and everything looks aligned in a separate column. I have 4 columns in excel.

I tried "DT_I4" and still got error msg. Is there something that I am doing wrong besides selecting "DT_I4"? I will try it again. do you know of a resource...