Error in excel import :Finding error while importing excel to SQL in SSIS with large text column

Question

I am trying to import the excel to SQL server table using SSIS package . In that excel one column has data more than 300 characters. While importing I am getting an error in excel source:

[Excel Source [12]] Error: There was an error with Excel Source.Outputs[Excel Source Output].Columns [ higher] on Excel Source.Outputs[Excel Source Output]. The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

Action taken:Tried by changing the data type as "Unicode text stream" by property Show advanced editor->input & output properties->external output columns.

Answer 1

Apparently your mapping in ssis is smaller than the real value in Excel, or your excel text have some character that your code page can't read.

You can unmap and map again your columns in the excel source or go to:

[Excel Source [12]] right click >> "Show Advanced Editor..." >> "Input and Output properties" >> "OLE DB Source Output" >> " + Output Columns"

and edit the commom Propertie "CodePage" and "Length" of your column.

If it doesn't work, try to ignore truncation errors on "Error Output" page.