In our application, we would like to export the user data. In the main table,
it is related to many other tables with foreign keys. We have not used DTS
before and would like to see if it can export the data for us. How can we
write a DTS package that will export from the main table, and all related
data from the other tables, into a single XML file that can then be imported
into another database? If this is possible, can someone provide a simple
example that I can build on? Thank you

Yes. you can use DTS to do your task. In the DTS wizard, use the 2nd option
"Use a query to specify the data to transfer." Then input your sql statement
joining several tables.

"Mike Collins" wrote:

Thank you for the relply, but since I sent this, we have decided to use
another method of exporting and importing data.

"ads" wrote: