I'm re-designing some SSIS packages for 2012 and some parameter/variable/configuration issues are not clear to me.
The result that I am trying to achieve is that the user context's temp folder(stored in the %temp% OS environment variable) is available in my package. Specifically, when I open the package in SSDT, it should expand the environment variable to the current path so that it passes validation. I can get this at run time with script task, but it's ugly working around it at design time. In the SSIS catalog, I can apply an environment variable to a parameter, so that aspect is not an issue.
How can I get this to happen when a project is opened?