sql server dts: Hi,

I have package on a single server. This packages extracts Data from
System A and loads System B, database C. What I'd like to do is use
configurations to have this one package loads System B, database C and D.



When a I create two configurations (one pointing at database C and one
pointing at database D) and run the package only the last configuration
pointing at database D gets loaded.



Anyone know how to get around this and use configurations to load both
database C and D?



Thanks,



Mark

--
Thanks,

You have to run the package first with one configuration and then with the
other.

1.- You can create a job with two steps one with one configuration and then
the other with the second configuration.
2.- Or you can just modify the package to load two tables and then specfiy
the two tables in a single configuration.
3.- If option 1 is not possible because your source change so quick and then
the two destination tables will be diferent you can use the package you have
to load and temp table, and the create a new package to get the data from
that table a load the two tables. But this is only if you have a realle
strange scenario.


cheers

--

Francisco A. Gonzalez
fgonzalez@solidq.com



[quoted text, click to view]

Francisco,

Yes the two steps method fixed it... Thank you !!!