Variable.GetPackagePath Methode

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Gibt den Pfad des Pakets zurück, zu dem die Variable gehört.

public:
 virtual System::String ^ GetPackagePath();

public string GetPackagePath();

abstract member GetPackagePath : unit -> string
override this.GetPackagePath : unit -> string

Public Function GetPackagePath () As String

Gibt zurück

String

Eine Zeichenkette, die den Pfad des Pakets enthält.

Implementiert

GetPackagePath()

Beispiele

Das folgende Beispiel erstellt ein neues Paket, setzt EnableConfigurations auf true, und setzt die Eigenschaft ExportConfigurationFile . Das Beispiel fügt dann eine neue Variable zur Variablensammlung hinzu, setzt den Wert und ruft den Paketpfad mit GetPackagePath. Außerdem wird eine Konfiguration zur Konfigurationssammlung der Paketwerte von , ConfigurationStringConfigurationType, und PackagePathhinzugefügt.

static void Main(string[] args)  
        {  
            // Create a package and set two properties.  
            Package pkg = new Package();  
            pkg.EnableConfigurations = true;  
            pkg.ExportConfigurationFile(@"C:\conf.xml");  

            // Create a variable object and add it to the   
            // package Variables collection.  
            Variable varPkg = pkg.Variables.Add("var", false, "", 100);  
            varPkg.Value = 1;  
            string packagePathToVariable = varPkg.GetPackagePath();  

            // Create a configuration object and add it to the   
           // package configuration collection  
            Configuration config = pkg.Configurations.Add();  

           // Set properties on the configuration object.  
            config.ConfigurationString = "conf.xml";  
            config.ConfigurationType = DTSConfigurationType.ConfigFile;  
            config.PackagePath = packagePathToVariable;  

            //save the package and its configuration  
            Application app = new Application();  
            app.SaveToXml(@"c:\pkg.xml", pkg, null);  

            //Reload the package  
            Package p1 = app.LoadPackage(@"c:\pkg.xml", null);  
            //Review its Variables collection  
            Console.WriteLine("The value of variable VAR = " + p1.Variables["var"].Value);  
        }  

Shared  Sub Main(ByVal args() As String)  
            ' Create a package and set two properties.  
            Dim pkg As Package =  New Package()   
            pkg.EnableConfigurations = True  
            pkg.ExportConfigurationFile("C:\conf.xml")  

            ' Create a variable object and add it to the   
            ' package Variables collection.  
            Dim varPkg As Variable =  pkg.Variables.Add("var",False,"",100)   
            varPkg.Value = 1  
            Dim packagePathToVariable As String =  varPkg.GetPackagePath()   

            ' Create a configuration object and add it to the   
           ' package configuration collection  
            Dim config As Configuration =  pkg.Configurations.Add()   

           ' Set properties on the configuration object.  
            config.ConfigurationString = "conf.xml"  
            config.ConfigurationType = DTSConfigurationType.ConfigFile  
            config.PackagePath = packagePathToVariable  

            'save the package and its configuration  
            Dim app As Application =  New Application()   
            app.SaveToXml("c:\pkg.xml", pkg, Nothing)  

            'Reload the package  
            Dim p1 As Package =  app.LoadPackage("c:\pkg.xml",Nothing)   
            'Review its Variables collection  
            Console.WriteLine("The value of variable VAR = " + p1.Variables("var").Value)  
End Sub  

Beispielausgabe:

Der Wert der Variablen VAR = 1