How can I extract XML from SQL using DTS

• Atiq Rahman

  SSC Journeyman

  Points: 98

  More actions

  June 12, 2004 at 6:36 am

  #65142

  Hi

  I am executing a SQL query which is using "for XML RAW" option in the DTS.

  The DTS is sending the output to a text file like 'myxml.xml'. 

  But when I open the Text file the result is in binary format, not in XML.  Can someone please help me.

   

  Regards,

  Atiq Rahman

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 14, 2004 at 8:04 am

  #510287

  You cannot do it that way at all. However take a look here for a way to accomplish using ActiveScript object.

   

  http://www.perfectxml.com/Articles/XML/ExportSQLXML.asp