DTS Export Truncates at 255

• JoeB

  Grasshopper

  Points: 11

  More actions

  July 23, 2001 at 2:22 am

  #77846

  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

  problem?

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

  mode.

• patilds

  SSChasing Mays

  Points: 615

  More actions

  July 23, 2001 at 5:50 am

  #417235

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