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.
"Mike Collins" wrote:
Quote:
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
you for any help.
|
Exporting Multiple Tables (then importing them to another db) -
08-29-2006
, 01:05 PM
Linear Mode
