Hi!

I have 7 source databases and one target database, all using the same structure. The structure is made of 10 tables, with foreign key constraints.

I need to merge the source databases into the target (which won't have any data before that process, but will already have the correct schema), and to keep the relationships between the records.

I know how to iterate over the source databases (with SMO foreach), but I'd like to know if someone can advise the best copy method for that context in SSIS ? (I don't want to keep the primary keys, but I need to keep the relationships...)

Any pointer most welcome!

best regards and thanks

Thibaut

Hi Thibaut,

if you have same  structure for all source table than you can use FOREACH LOOP  TASK.

But best copy method is BCP. you can use Script Component and BCP class library

http://www.sqlservercentral.com/Forums/Topic1158545-149-1.aspx

Regards,

Manish