ERROR CODE:- [Excel Source [1]] Error: The "output column "Msi Notes" (90)" failed because truncation occurred, and the truncation row disposition on "output column "Msi Notes" (90)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. [Excel Source [1]] Error: There was an error with output column "Msi Notes" (90) on output "Excel Source Output" (9). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". Regards, Vipin jhaThankx & regards, Vipin jha MCP

Hi vipin, Its because of the lehgth of the record. Increase the size of the Msi column in destination. if you want to avoid the error means use dataconversion component and fix the length of that particular column. or you acn redirect the error row by configuring error out out column. For example in your source if coulmn size is 255 and destination is 30 means , this type of errors will happen.

SIZE OF THE DESTINATION COLUMN IS OKThankx & regards, Vipin jha MCP

Hi Vipin jha, http://stackoverflow.com/questions/8629024/text-was-truncated-or-one-or-more-characters-had-no-match-in-the-target-code-pag http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/0c245265-79fc-406c-8ec6-6019eebc4f68/ http://www.bradleyschacht.com/excel-source-the-output-column-failed-becuase-truncation-occured/ Thanks, Khilit http://www.bigator.com

Hi vipin, Go though the link below for your referenec.Just change the column length in Advanced Editor for the Excel Source and you are good to go! http://www.csharpest.net/?p=153 Thanks, Saikat

update your column length for source.