I am encountering an error with a Unicode text file as my source. It is a delimited file using the | cahracter, which is not my problem. The problem is when one the delimited fields exceeds the 255 character limit, I get the Format error detected in rows: 1 error.
I know that at this point in the DTS package, I am not looking at the destination table, for which the destination field in an nvarchar datatype with 4000 characters as the length.
0 · ·