If you have to choose between staging tables or excessive locking and logging by the SSIS OLE DB command, I'd choose staging tables any day.

(tell that to your DBA 🙂

Temp tables are a viable alternative, but they can put an extra burden on tempdb, so I hope your DBA has put it on a fast disk.

If you want to use them, you need to make sure they are created before they are used in the data flow. You also need to put the data flow to DelayValidation equals true.

Finally, to make sure the temp table still exists before the data flow actually uses it, you need to put the property RetainSameConnection to true on the connection manager.