we are trying to read a csv file and truncating some columns because our table would be too large otherwise. Unfortunately deploy and execute fails with this error:
"Data conversion failed. The data conversion for column "name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."."
We are pretty sure it isn't an encoding problem because when we increase the column size ("Length") in "Edit multiple text files"->"Columns" we can read the data just fine so the error must occur because of the truncation.
Does anybody know what options we have to use to let TimeXtender know that we are ok with the truncation of the data in the columns?