Hi,
1st. Issue
I have written a package that uses an environmet variable which contains certain information that the user must enter. A sql script task will then get the information from the environment variable and manipulate it.
I don't have a problem programmatically getting information from the environment variable. However, when I manually edit the contents of the environment variable, the changes won't take place unless the box is rebooted. Is there a way to refresh environment variables without rebooting?
2nd. Issue
I have written another package that also reads data from an environment variable but it must also manipulate the data and save the changes to the environment variable.
I have accomplished this programmatically by using GetEnvironmentVariable() and SetEnvironmentVariable(), but unfortunately the changes live during program execution only. Afte the program executes, the changes are wiped out.
How can I make changes stick to environment variables (programmatically)?
-- I found a solution to this:
When programmatically getting and/or setting an environment variable the 'target' parameter must be specified in the method call. By 'target' I mean the location in the registry where your environment variable is stored.
GetEnvironmentVariable( var, target )
SetEnvironmentVariable( OldValue, NewValue, target )
Please visit this link for more info:
http://msdn2.microsoft.com/en-us/library/96xafkes.aspx
No comments:
Post a Comment