hi,
i want to use dts to transfer data from one sql server to another. lets consider that i have 4 tables A,B,C,D. i have identity coulm in every table which is primary key of taht table. also primay key of table A is forign key in table B, and primay key of table B is forignm key of table C and primary key of table C id forign key of another more than 10 tables. how shuld i transfer this data which distutbinmg foreign key - primary key relation .can any one help me.
thanks in advance
santaji

If you take a look at the options tab in the "Transfor Data Task Properties" you should find an option called "Enable identity insert" in the SQL Server section at the bottom of the dialog box. Also, depending on how much data you have, it is recommended to change the "Insert batch size" to something like 10,000 so that your entire transaction (table) doesn't have to commit at one time...

Good Luck!

Jeff