Post reply

Use DTS to convert or filter html out and deposit as text

  • November 21, 2004 at 4:12 pm

    #60608

    I have a column in SQL which stores project descriptions with html before and after the text.  We export the descriptions to Access using a DTS package (copy column.)  I need to know how to use ActiveX or VB, etc. to either convert to text before it goes into Access or filtering the html code out might also work.  I have not had any success trying either of these.  Would it be best to convert to text or to try and filter the html code out?  I'm relatively new to DTS and am unsure of where in the transformation step to insert the appropriate code (if I have it.)  For example - before or after the existing "copy colum" task, etc.

    Thanks!

  • November 21, 2004 at 5:54 pm

    #530980

    Please post some sample data - both source and how you would like it to look after processing.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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