I have a flat file inside which contains a string with special character ¦. Also an SSIS package is used to move the contents of this flat file to a table. There are basically 3 compontes in the pacake 1. Flat file with connection 2. Derived Column 3. OLEDB connection to insert data to table
And when I am inserting I am getting below error
"The data conversion for the column returned a status value 4 and status text as Text was truncated or one or more characters had no match in the target code page"
The column data type is DT_STR in derived column
The special character ¦ is causing this problem. This character when rentered is treated as 2 characters as Ħ. The column size defined is 10 and when this character is present it breaks it as 11 and we get that error above.
Changing the out put column length to 11 will solve this issue. Will this break while inserting the entry to table as table column size is 10.
But i feel like this is not a better solution approach as in future if the source file has 2 broken pipe symbols as compared to 1 now.At that time the size again will have to be changed
I was able to recreate the error.
I changed the output column to data type : DT_TEXT under advance editor in flat file source.
Hope it helps
