DTS Package Text File Source Error - Programmers Heaven

Howdy, Stranger!

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


DTS Package Text File Source Error

rsteevesrsteeves Posts: 1Member
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.