Transformation from XML file

• nghendry

  Old Hand

  Points: 325

  More actions

  June 20, 2002 at 1:16 am

  #104984

  How can I do transformation from XML file to database SQL Sserver using DTS?

  example : i have employee.xml

  i need to transform from this xml file to database Employee (TMas_Employee --> table name) in SQL Server

  thanks before ... 🙂

• crosspatch

  Hall of Fame

  Points: 3168

  More actions

  June 20, 2002 at 4:45 am

  #431221

  OPENXML in TSQL is the more normal way than using DTS.

  You could try using ACTIVEX scripting in DTS and access MSXML as an automation object, (simlar to the way Andy accseses the FileSystemObject in his article on this forum.)

  Never tried it but it might well work given some encouragement.

  Cann't understand why MS didn't include XML in DTS on 2000

  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961

  
  I have found it is possible to please all of the people all of the time if you do exactly what they want. Harold Macmillan 1961