Temp Table created in one Execute SQL Task is not available in another Execute SQL Task in SSIS

Question

I created one Global Temp Table in one Execute SQL Task and the inserted some records into that table. While calling the result in another Execute SQL Task it is saying invalid object name.

Please suggest

Thanks Sasi

Answer 1

If you put both Execute SQL Tasks in the same Sequence Container and set the TransactionOption to Required on the Sequence Container you can access the global temp table from the second Execute SQL Task. You can leave the TransactionOption at the default of Supported for both Execute SQL Tasks, as they will join the transaction of the parent Sequence Container.