Temp tables can be used in ssis 2005

but for this feature to work you shud set the RetainSameConnection property to true in the Oldedb/Sql Connection.

Once you set this the connection will remain same and can be recognized by the server

Note: Temporary tables exist only for the connection. Global temporary tables can be accessed over different connections