I am getting the following error on my SSIS import process.
"Workbook.Outputs[Excel Source Output].Columns[XYZ]" failed because truncation occurred, and the truncation row disposition on "Workbook.Outputs[Excel Source Output].Columns[XYZ]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component."
I understand the issue relates to the column XYZ being too large, and it being truncated. But for the life of me, I cannot figure out the solution.
In my database, this column is set to NVARCHAR(512). The column in question only has a max value of 265, but something in my SSIS package isn't updating to the column size.
In my Data Source step, I did the following:
- Right Mouse Click and go into Advanced Editor
- Went to Input and Output Properties
- Checked column in question in "Output Columns" and the Length is set to 512 Unicode string [DT_WSTR]
- However, I noticed in the "External Columns" portion, the Length is only 255. However, I cannot seem to update this value, as every time I change it to 512, it reverts back to 255
As such, I am not sure if the "External Column" in the Advanced Editor is the issue and if it is, how to update the value and keep it from reverting back to the original 255 value.