>Hi,
>
>I'm having trouble with the DTS Import wizard in SQL Server 2000. I'm trying to import a text file with a field that holds just over 500 characters in length. There are no extended characters in the field, the field has a comma at the end of it seperating the data from the next field as expected and no comma in the actual data of the field. Yet when trying to import the data in this field to a Varchar field set to any length (greater than the following specified number) it always truncates the data at the 453 character consistantly on all rows in that column. I've tested this on two differnt machines and with two completely seperate text files.
>
>Does anyone know if this length of 453 characters a finite length for a field in the DTS wizard or am I doing something wrong here.
>
>Many thanks in advance.
>
>Ian.

See if this MSKB article helps: http://support.microsoft.com/support/kb/articles/q247/5/27.asp