Ok so on the outside of the script task you have a box to enter names of
variables into a ReadOnly colllection. Is your variable listed there?
No matter, its better to do this inside the task anyway.
OK So let's say I want to grab the PackageName system variable
withinside the script task here is how I would go about doing it.
Public Sub Main()
Dim vs As Variables
Dts.VariableDispenser.LockOneForRead("System::Pack ageName", vs)
MsgBox(vs(0).Value.ToString())
vs.Unlock()
Dts.TaskResult = Dts.Results.Success
End Sub
--
Regards
Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com
"vnapoli" <vnapoli (AT) discussions (DOT) microsoft.com> wrote
Quote:
How does one reference a ssis system variable from inside a script task
object ( i.e. System::machinename)? Whenever I attempt it, I get an
error
that it is unable to find the variable. |