dts import is truncating a text field

• kate_cha

  Old Hand

  Points: 351

  More actions

  January 13, 2006 at 7:42 am

  #60308

  I'm using the dts import/export wizard to import a csv file into sql - all works well apart from one long text field, which is always truncated at 256 characters - even though it throws no error messages.  I've tried importing as a varchar, text, nvarchar but none of them import the field correctly.  Any ideas?

  thanks!

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  January 13, 2006 at 11:16 am

  #614704

  Kate - please follow this link to read about how another member faced the same problem and resolved it!

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**