You won’t be able to use temporary tables with SSIS. Temporary tables are only good for the length of the session. Once the session ends (IE, you disconnect) the table is dropped. Each widget you add to the SSIS package is it’s own connection to the SQL Server. You will want to create a normal table and simply setup the job to truncate the table before loading the data into it, then use that table to handle your delete.