Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Use DTS to export a table to XML

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-11-10 : 15:19:21
How to use DTS to export a table to XML file?
I do not see sqlxmloledb under desination.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-10 : 15:24:04
I'll use an ActiveX Script task for that
Go to Top of Page

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2009-11-10 : 15:42:15
Can you tell me more detail?
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2009-11-10 : 18:40:56
using an ActiveX script, you can generate the xml file using the DOM. have a look here: http://msdn.microsoft.com/en-us/library/aa468547.aspx and here: http://msdn.microsoft.com/en-us/library/ms950789.aspx
Go to Top of Page
   

- Advertisement -