• 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