DTS Package Text File Source Error

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.

Any thoughts.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!