Hi, the flat file source you are using, is it a normal text file,or perhaps csv?
Rerun your job and look for a column name that is giving the issue.
I know you will have issues dumping txt to float as well. i.e. string type characters.
I had a similar issue once, but resolved it by changing the source data, and the output column format from float to nvarchar.
Awaiting your reply.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle