Hi,
I'm trying to migrate data from one table to two tables. The two destination
table is connected with foreign keys, so I have to insert some data into the
first table than insert the remaining data (with that primary id as a foreign
key) into the second table.
Is there a simple way to do that with Integration Services 2005 ?
The only solution I came up with is using OLE DB Command with output
parameters but it's painful.

(btw the sample task is to migrate employees from northwind to
adventureworks contacts and employees tables)

any ideas?
thanks,
steve