• I suggest you divide and conquer to identify the data with the issue.

    Either slice your source file up into chunks and iteratively load it to identify the offending row(s)

    OR load the file into a table consisting of VARCHAR(8000) columns, and an identity column to give you the source row number, then select the data and cast on the fly to find the row with the problem:

    SELECT CAST(CORPOL25_DOLL_60P_PCT,DECIMAL(9,9)) As Test FROM YourTempTable WHERE YourIdentityColumn BETWEEN 90000 and 95000

    Its a brute force method but it lets you identify the exact piece of data causing the issue.