Insert a row, then get the primary identity key for use a foreign key.
Hello All,
I have been bashing my head against this one for a while and I am not coming up with any good solutions. I am performing an extract, transform and load of a legacy database into a new schema. The DB folks chose to build a OO type schema where there is a Parent table with a primary identity key and the child table has a primary key that is also a foreign key containing the identity key of the parent table. So, upon extraction, I need to create a row in the parent table, get the primary key that is auto generated by the identity property in the parent table, then use that key as the primary key as the child table when I map the child table attributes.
Does anyone have suggestions here? I have started thrashing and am no longer making progress.
Thanks,
Jim Long
Hi Jim, Were you able to find the solution of your problem. I am asking this because I am facing the same problem when trying to insert data in child job and sharing the database connection between the parent and child job. Any help will be highly appreciated. Thanks, Priyanka
Hi pbhat2
This topic was rather old, in order to better follow up your topic, can you please report a new topic with details for problem.
Thank you!
Shong
