hi,
can you show me how to get the value of an environment variable from a script task?
thanks!
http://msdn2.microsoft.com/en-us/library/system.environment.getenvironmentvariable.aspx|||
Public Class ScriptMain
Public Sub Main()
Dim home As String = System.Environment.GetEnvironmentVariable("HOMEDRIVE") + System.Environment.GetEnvironmentVariable("HOMEPATH")
Dts.Variables("MyDocuments").Value = Path.Combine(home, "My Documents\")
Dts.TaskResult = Dts.Results.Success
End Sub
There is a sample package that illustrates the method in action here -
Environment Variables- Raw Files
(http://wiki.sqlis.com/default.aspx/SQLISWiki/EnvironmentVariables-RawFiles.html)
No comments:
Post a Comment