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

1 Answer

6 votes

Final answer:

To create and use a temp table in an SSIS Package, set the 'RetainSameConnection' property to True on your database connection and the 'DelayValidation' property to True on tasks that use this temp table. This allows the temp table to persist and be used across different tasks.

Step-by-step explanation:

In order to create a temp table in an SSIS Package and to use it in other tasks, you'll have to work with certain properties. Specifically, you need to set the RetainSameConnection property to True on your database connection, so that the temp table persists beyond the task where it was created. You also need to set the DelayValidation property to True on tasks that use the temp table, so they don't fail validation due to the table initially not being seen.

Example: First, a Execute SQL Task might be used to create the temp table. Other tasks (like a Data Flow Task) that come afterwards can then use the temp table, because the connection is retained and the validation happens at runtime, not at the time of package validation.

Learn more about SSIS Package

User Jarmo
by
8.3k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.