Hi, has anyone tried to use # temp tables with Source/Destination data flow
components? If I choose destination and create a new temp table, it cannot
retrieve it. That's obvious after the fact that #temp table lives in a
connection and die after connection terminates. But how can SSIS work with #
temp tables if that was the case?

In the SSIS data flow I even have a separate flow that creates the #temp
table, but since it's not running during design time the subsequence use of
#temp table is not valid.

The alternative for now is to create a permanent temp table that's not a
real # temp table. Will SSIS be improved so #temp will work?