DTS Export Truncates at 255

  • I am having DTS problem exporting from a table to a text file (my 600

    character table column is truncated to 255 characters in the output text

    file). I don't why this is happining nor how to get the DTS not truncate to

    255 characters. Is this a bug? A limitation? How do I get around this


    .......I am running SQL Server 7 SP1 and database is in 6.5 compatability


  • SQL Server 6.5 varchar field can contain max 255 characters . Thats why the problem is. Update your driver to 7.0 or above.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply