Persistant variables

Greetings SSIS friends.

Is it possible to create a persistant variable in an SSIS package?

dreameR.78 wrote:

Greetings SSIS friends.

Is it possible to create a persistant variable in an SSIS package?

Meaning what, exactly?|||

The variable retaining its value after the package is run.

|||

dreameR.78 wrote:

The variable retaining its value after the package is run.

I suppose there are progmatic ways of doing this, but the "easy" way that I can see is to use SQL Server based package configurations. At the end of your package, you issue an Execute SQL Task to update the configuration table to set the value of the variable in the table to that variable's current value.|||

Hi Phil,

I will try your suggested method.

Thank you.