VariableDispenser.GetVariables Method
Locks the variables that are in the read-only list and the read/write list.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
Call this method to lock all the variables previously added to the read-only list or the read/write list.
If the call succeeds, the lists are freed and the requested variables are combined into a single collection, with each variable locked for the access specified. To unlock the variables, release the variable collection using Unlock on the Variables collection.
If the call fails, the lists remain, but the variables are not locked.
Note
|
|---|
|
It is desirable to maintain a lock on the variable for the minimum amount of time required. This allows other components and tasks to acquire locks and facilitates sharing of the variables. |
The following code example creates a VariableDispenser and adds two system variables to the list that is locked for reading. Then the GetVariables is called to lock both variables in the collection, and the lists are freed and made available for new variables.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; namespace Microsoft.SqlServer.SSIS.Sample { class Program { static void Main(string[] args) { Package pkg = new Package(); Variables vars = null; VariableDispenser variableDispenser = pkg.VariableDispenser; variableDispenser.LockForRead("System::PackageName"); variableDispenser.LockForRead("System::OfflineMode"); variableDispenser.GetVariables(ref vars); // Verify that the variable is locked before unlocking. Console.WriteLine("Variables are locked? {0}", vars.Locked); foreach (Variable myVar in vars) { Console.WriteLine("Name {0}", myVar.Name); Console.WriteLine("Description {0}", myVar.Description); Console.WriteLine(); } // Use Contains to determine whether indexing can be used. Boolean pkgName = variableDispenser.Contains("PackageName"); String qName = variableDispenser.GetQualifiedName("PackageName"); Console.WriteLine("Contains is valid? {0}", pkgName); Console.WriteLine("Fully qualified name is: {0}", qName); vars.Unlock(); Console.WriteLine("Variables are locked? {0}", vars.Locked); } } }
Sample Output:
Variables are locked? True
Name OfflineMode
Description The offline mode currently set for the package
Name PackageName
Description The package name
Contains is valid? True
Fully qualified name is: System::PackageName
Variables are locked? False
