No one has followed this question yet.
Joining to local tables vs #temp tables
Cursor runs faster on Physical tables versus Temp Tables?
You executed this command to create a temporary table: (inside) What is true about the rows inserted into the REPORT_WORK_AREA table during a transaction after commit?
temp table vs data flow task on physical table
How to resolve RESOURCE_SEMAPHORE and RESOURCE_SEMAPHORE_QUERY_COMPILE wait types