Any know issue with text datatype

• tome-473314

  Old Hand

  Points: 309

  More actions

  February 13, 2008 at 3:14 pm

  #186509

  I have a DTS package that does a DTS lookup and it fails because the table it uses has one of the column with text datatype. This DTS fails with error "No such interface supported". When I change the type from text to varchar the DTS runs fine. This same DTS used to work fine at some point of time.

• arifrefai

  Grasshopper

  Points: 13

  More actions

  February 14, 2008 at 7:43 am

  #778348

  Try converting the text field into Varchar(8000) and pulling the data ..

  So what is ur problem now ??