Question

If we create a temp table in SSIS Package and want to use it in other tasks, which properties do we need to use?

Answer 1

You have to use RetainSameConnection property for connection manager.

This property indicates whether the connection manager retains the same connection.