The data type is DT_NTEXT, which is not supported with ANSI files

For anyone looking for an alternative solution;

• Edit your Flat File Connection Manager
• In General tab
• Tick ‘Unicode’, OK

This solved the above problem for me.