I'm writing an SSIS package that imports data from an Oracle database. There's a chance some rows are already in the destination table, and seeing that there's no task in SSIS 2008 that allows me to check this, my idea is to create a temporary table and use a field in the destination table to filter the temporary table's rows that I can actually insert.

I understand that local and global temporary tables [vanish when they go out of scope](https://www.simple-talk.com/sql/t-sql-programming/temporary-tables-in-sql-server/). So, my question is, when my SSIS package goes on to the next task, will my temporary tables disappear?