The likely issue is that you have a source and target that are two different data types (ANSI and UTF8).

Perhaps you ran an SQL statement to dump data from a table directly to disk and it defaulted to the UTF8 format, whereas your SSIS job is trying to load it to ANSI.

Typically, I have to convert whatever flat file I'm using to ANSI (if small, open it in notepad and save it as ANSI) in order to get rid of this issue, but you may be able to get around it in SSIS.

Darn, should have read through to page 2 before posting. 😀