• Before you eliminate the #temp table, take a look at this link and see if it's ideas help solve the #temp table issue.

    http://www.sql-server-performance.com/2013/temp-tables-ssis/

    As far as the error message, I will tell you that SSIS is notorious for giving messages that lead you nowhere. So, they are of use to a marginal extent, as in CLUEs, but often misleading.