Using Temp Table in SSIS
In some instance you have no choice but to use Temp Tables in your SSIS Package. In this tutorial video i'll go though some of the SSIS Package settings you need to change before temp tables will be enabled for your SSIS Package to work.
Refer to this excellent article for more info
https://www.mssqltips.com/sqlserverti...
Article on Global (double Hash) and Local Temp Tables (single hash)
https://www.red-gate.com/simple-talk/...