SSIS Data Conversion Redirecting Rows to Error Output Despite Valid Data

Cuamsia 0 Reputation points
2025-05-15T15:52:02.09+00:00

I have a Data Conversion component in SSIS that keeps redirecting rows to the error output despite the data being valid. The FIRE_SIZE_CLASS column only contains single characters A-G, confirmed through inspection, and the conversion is set to DT_STR with a length of 1 and code page 1250. However, thousands of rows are still sent to the error output with the error:

Data conversion failed while converting column "FIRE_SIZE_CLASS" (359) to column "FIRE_SIZE_CLASS" (141). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."

The Data Viewer shows only valid single characters, no extra spaces, nulls, or unexpected characters. What could be causing this truncation error in SSIS?

User's image

User's image

User's image

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,700 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Olaf Helper 47,416 Reputation points
    2025-05-16T05:53:08.09+00:00

    Text was truncated or one or more characters had no match in the target code page."

    The data is may valid, but alos may to long and would be truncated.

    Check the data length of source and destination column.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.