Craig Farrell (11/15/2010)
You're already in trouble. SSIS should not be working with #tmp tables outside of a *single* Execute T-SQL object. It does not guarantee a consistent batch.
If you set the property RetainSameConnection to True of the corresponding connection manager, there should be no problem. (if all task/components that use the temp table have the same connection manager of course)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP