Hi,
i want to create DTS package in SQL Server 2000. It should transfer some transaction tables like OrderHeader and OrderDetail. Both are inter-related by orderid (Identity COlumn). I want to transfer these two tables from one database to another. For each transaction the destination database may create different Orderid in orderHeader. That orderid should be mapped to destination orderdetail table also.


Any solutions, please?