thanks for the Help

I am using SSIS 2008 to import data into Sequel Server. Source are text files

Not sure if this is best method of doing this but the auto int field in the parent table is the link between the 2 tables. So basically I add a record to the Parent table which creates the auto int field and then also wish to add a record to the child table to maintain the relationship. I need to retrieve that auto int field so that i can add it to the child table.

So in the SSIS i have a source and 2 destinations...record goes to parent table and also to child table..

Is this any clearer

regards

Fred