Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dhw
Constraint Violating Yak Guru
332 Posts |
 Posted - 2006-11-16 : 01:39:13
|
| 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. And, as part of this I will need to get the latest ID value and possibly some other values and store them in variables.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 |
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2006-11-17 : 11:23:40
|
| I finally figured this one out on my own. |
 |
|
|
joksimovic
Starting Member
1 Post |
Posted - 2011-07-17 : 07:24:40
|
| Hi,I know that this topic is too old, but could you please explain me how you did it?Best,Joksimovic |
|
|
|
dhw
Constraint Violating Yak Guru
332 Posts |
Posted - 2011-07-17 : 14:49:07
|
quote:
Originally posted by joksimovic
Hi,I know that this topic is too old, but could you please explain me how you did it?
Hi - Wow, this is old! I'll need to dig deep into the past to see if I still have the code/ssis package around. It might take a few days. |
|
|
|
|
|
|
|
|
SSIS - insert into child tables