blogs.conchango.com

Update below There has been, and still is, quite alot of conjecture in Conchango as to whether one should use SSIS data-flows or stored procedures for ETL. Traditionally we have implemented ETL solutions using stored procedures. DTS was used but as little more than a workflow engine, occasionally using the data-pump for importing data from ...

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 ...