2 votes
Accepted

DFT drops connection and its temporary table after leaving any DFT item, tested with two Script Components. How do I keep the temp table alive?

All you have to do is add an ADO.NET connection manager for SQL Server to your project and set it to "RetainSameConnection". Then each script task can access the same SqlConection object. ...
David Browne - Microsoft's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible