Monday, 9 June 2014

Truncation error while executing SSIS package-Importing tables from different data sources.


Error Message-

0xC020901C at Data Flow Task, OLE DB Source [79]: There was an error with OLE DB Source.Outputs[OLE DB Source Output].Columns[XYZ] on OLE DB Source.Outputs[OLE DB Source Output]. 

The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".

Solution-

Double click on your source (oledb ,Flat file etc) --> OleDB Source Editer --> Error Output.
Select column having truncation error -->  set it to ignore failure.

Do the same for all columns having truncation error.



 Thats it now save and run the package.:-)

No comments:

Post a Comment