timmitchell.net
Temp Tables in SSIS - Tim Mitchell
Temp tables are very handy structures for interim data manipulation during ETL processes, but using temp tables in SSIS (especially in the data flow) can lead to unexpected failures. In this post, we highlight the challenges of using temp tables in SSIS and propose some more robust workarounds for interim ETL tasks.