SSIS Flat File error "Text was truncated or one or more characters had no match in the target code page."
Check out this link:
Two ways for addressing the problem are described.
Vian Ojeda Garcia
Updated on June 26, 2022Comments
-
Vian Ojeda Garcia almost 2 years
I am working on a SSIS project. I have a Flat File Source (csv) and OLE DB as destination. I have a column named
WrapUpName
with a data typeUnicode string [DT_WSTR]
with aOutputcolumnwidth - 50
that only contains either of these dataSuccessfull,Unsuccessfull,ACPS FC: Always Busy or Ringing or Unattended
and my destination column isnvarchar(50)
I had these error message
Data conversion failed. The data conversion for column "WrapUpName" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."
It's really weird because upon checking of the error row the data in column
WrapUpName
isSuccessfull
which is handled by my IS with no problem. Upon researching I know that the fix is settingcode page
toUTF-8
which I did from the first time or adjusting the length of data type which is correct but I want to know what triggered the error.