Temp tables in DTS

[Faithalone1]

Is there a way to specify a destination table as a temporary table i.e. #tablename in DTS.&nbsp;&nbsp;I'm trying to pull data from an ODBC connection into 2 temporary tables and <br>then join those tables into a new permanent table, and then drop the temp tables.&nbsp;&nbsp;