DTS Function

• Green Armchair

  Hall of Fame

  Points: 3561

  More actions

  September 12, 2002 at 5:16 am

  #63958

  Hi

  I'm creating DTS packages to load data from text files. I'm finding that a lot of the data needs to be transformed in the same way (e.g trailing "." removed). Rather than writing individual activex scripts to do this, is it possible to write my own DTS function which I call from my DTS packages?

  Thanks

  Andy

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  September 16, 2002 at 11:08 am

  #436608

  You could using VB or C++, but sure it's more efficient.

  2 thoughts. Parse the file first and "fix" the data, or load it and fix it using SQL.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones