Hello
I am trying to export a SQL Server 2000 table to XML file. When I open DTS import/export wizard there is no option in Destination section for XML. How do I do this???

It's surprising isn't it that there's no direct built-in support for this. For a pretty comprehensive list of the options see http://www.PerfectXML.com/Articles/XML/ExportSQLXML.asp

IMO the bcp option is the most useful general way. Although the sp_makewebtask way can be good too if your xml is small and you have sysadmin rights!

hth
Phil