Hi All, i have a table in excel as below. and i am trying to move records from excel to SQL.
Code Template ExportType
A002 A002XM08 DST
--- ------ ---
I have simple SSIS package with Excel Source, data conversion task and OLEDB Destination. and in data conversion i have given the data type string(DT_STR) for each of the column and length of data type same as each column is having in sql database but still
it fails at data conversion task and gives the following error:
Error: 0xC02020C5 at Data Flow Task, Data Conversion : Data conversion failed while converting column " ExportType" (3519) to column "Copy of ExportType" (3533). The conversion returned status value 4 and status text "Text was truncated or one or more
characters had no match in the target code page.".
Error: 0xC020902A at Data Flow Task, Data Conversion : The "output column "Copy of ExportType" (3533)" failed because truncation occurred, and the tr
View Complete Post