|
|
Browse by Tags
All Tags » SSIS » SQL Server » SQL » T-SQL
-
It is a very common scenario to be able to load two tables in the same data-flow that have a foreign key relationship between them. The question of how to do this gets raised very often on the SSIS forum so I figured I'd try and address it here.
Basically, its not possible to do this without using a workaround. There are two possible workarounds ...
-
I got some smashing advice from a guy called Steve Kass today that I wanted to make sure I kept and remembered. I thought about the best place to store it and I thought, well why not right here on my blog. That way I won't forget it and maybe other people can benefit too.
Thanks for your help ...
|
|
|