Exporting from multiple tables -- sql server dts

Mike Collins
8/23/2006 12:40:01 PM

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

ads
8/28/2006 3:10:02 AM

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.

[quoted text, click to view]

Mike Collins
8/28/2006 7:38:02 AM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Exporting from multiple tables