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