Exporting data to XML file

• jmasson

  SSC Veteran

  Points: 224

  More actions

  August 18, 2008 at 11:57 am

  #192501

  We currently use a DTS package to extract data from the db and export it in an XLS file, or in some cases a TXT file. We now need to be able to export as an XML file. Since SQL Server 2000 DTS functions do not appear to support this directly, can anyone give us guidance on how to proceed?

• Maksymilian Mulawa

  Ten Centuries

  Points: 1336

  More actions

  August 28, 2008 at 7:18 am

  #864345

  Can you just not use FOR XML with SELECT statement, and save the output as text file with xml extension?

  Cheers, Max

  Check-out free open-source utility Sql Server Replication Explorer[/url]