I am trying to migrate two tables (A & B) from the source
to destination. B references (FK) to A.
(col_1_A idenity PK ,col_2_A int)
(col_1_B idenity PK ,col_1_A FK, col_2_B)
In the destination database both have identity values so I
want to first copy across data of Table A , and later on
read the destination table A for migrating Table B and get
the new FK values.
How do I handle this in DTS?
In the DTS can I lookup into a table residing on another
database whilst transformation
Thanks in advance