sql server dts: Exporting Multiple Tables (then importing them to another db) -- sql server dts

Exporting Multiple Tables (then importing them to another db)

Mike Collins
8/29/2006 11:05:01 AM

sql server dts: We need to have a DTS package that takes in a parameter and exports records
from a main table that match the parameter and then exports records from
other, related, tables. Then a DTS package that imports this same data into
another db of the same structure. Can someone help me get started on this or
point me to a website that talks about this. I have seen very simple exports
from one table, but I'm not sure how to implement it with many tables. Thank

RE: Exporting Multiple Tables -- Part 2

Mike Collins
8/29/2006 11:11:02 AM

I forgot to say that I am using SQL 2000 and we are thinking we might want to
export the data to an XML file.

[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 in the sql server dts group.