Why Does A Global Temp Table Created By An Ssis Package Disappear After Completion?

At the start of ETL package the following SQL query runs against a SQL Server 2012 database: IF OBJECT_ID(N'tempdb..##SlotChanges') IS NOT NULL BEGIN DROP TABLE ##SlotChanges END

Solution 1:

Global temporary table is dropped automatically when there aren't any active connections using it. It's a temporary table.

http://www.sqlservercentral.com/blogs/vivekssqlnotes/2012/01/07/sql-server-global-temporary-tables/

Solution 2:

your understaing is bit incorrect. Global Temp table get drop when last session using it compelets.

" Global temporary tables are automatically dropped when the session that created the table ends and all other tasks have stopped referencing them. The association between a task and a table is maintained only for the life of a single Transact-SQL statement. This means that a global temporary table is dropped at the completion of the last Transact-SQL statement that was actively referencing the table when the creating session ended. "

chekc the MSDN Create Table