sql server dts: I have an interesting scenario. I have to exact table
structures for 2 identical systems that function the same
way. There are 3 tables that are linked via primary keys,
ex.
table 1
table 2 - linked to table 1 via table 1 ID autonumber key
table 3 - linked to table 2 via table 2 ID autonumber key

Now I need to consolidate the systems into one, the
problems is that there is data in each system and I need
to keep the linkages enact. The key values can change but
they need to keep the relationship. The ID values that
they would go into are already take (ex 1, 2, 3) so it
would need to create new key values for the imported
data. Is that possible, how?

There's some way to set the relationships to cascade key updates I
believe. Perhaps before importing data update the keys to values that
you know are not used in the destination table.