ETL tool encapsulating DTS ?

• elliot@datahabitat.com

  Valued Member

  Points: 59

  More actions

  November 18, 2002 at 5:08 pm

  #105556

  Does anyboby know of any ETL tool that (1)encapsulates DTS, i.e., automatically generates DTS packages based on metadata definitions, and (2)requires no programming?

  Thanks!

• philcart

  SSC-Forever

  Points: 47795

  More actions

  November 19, 2002 at 7:24 pm

  #441789

  Check the SQL Server Accelerator for BI from Microsoft.

  http://www.microsoft.com/solutions/BI/nextsteps/default.asp

  Haven't tried it myself but it's supposed to build the DTS packages required for loading a Datawarehouse.

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface