Very Computer

Table A
(col_1_A idenity PK ,col_2_A int)

Table B
(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

Ashu

try DTSLookups

Bart

Quote:> I am trying to migrate two tables (A & B) from the source
> to destination. B references (FK) to A.

> Table A
> (col_1_A idenity PK ,col_2_A int)

> Table B
> (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

> Ashu