hello -

i am trying to figure out how i can create an SSIS package to insert into
multiple tables. After the first insert, I want to take the ID created (an
Identity column) and then use that to insert into other associated (foreign
key) tables.

For example, I have a table Users. The primary key is an Identity column.
Once the SSIS insert is complete, the bulk load of new users has an identity
ID value for each row. What I want to do, during the same SSIS package, is
to take each row as it is inserted and add rows to other tables. Like,
UserDepartment - it has a foreign key for the user id and a foreign key to
the department being added.

I looked at multi-cast, but I don't know/think that this will work for me.

does anyone know of a good example or article like this?

thanks
- will