I am trying to upload an excel spreadsheet source to one table in sql 2008 standard databse.
i have truncated the table first in control flow, gone for data flow to update spreadsheet.
i received the error on one datatype, not able insert. please steps i have taken and spreadsheet source.
I am new at this and trying to do some of the tutorials as well, any suggestions greatly appreciated.
Error at Data Flow Task [pinvrep08 ]: The column "account_type" can't be inserted because the conversion between types DT_R8 and DT_I4 is not supported.
Error at Data Flow Task [SSIS.Pipeline]: "component "pinvrep08" (57)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.