DTS ActiveX Script to combine multi-line input record into a single-line record

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  August 9, 2004 at 11:31 am

  #60179

  I am looking for an example or the how-to-steps on combining multi-line records (from an input text file) into single-line records on a text file or SQL Table.

  Also, if you have an example of how to create multiple destination records from a single source record (from a text file) using an AxtiveX Transformation I would greatly appreciate it.

  I need the first example the most. Thanks in advance.

  Kevin

   

   

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  August 10, 2004 at 7:36 am

  #518305

  You should be able to find examples of both at http://www.sqldts.com