Temp tables not being created in SQL Server Azure
To do this you will need to use global temp tables, i.e. ##TempTable.  Additionally, the TransactionOption property will need to be set to Required for the the parent container of all the objects involved.  This will keep all of the SSIS components in the same transaction.  Within the container, the tasks can use use the same Required level or Supported, which will inherit this property from the parent container.  All the components involved can either be placed within a Sequence container with TransactionOption set accordingly to isolate them, or this can be applied at the package level.