LogProvider.GetPackagePath Methode

Definition

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Gibt eine Zeichenfolge zurück, die den relativen Pfad zum Paketspeicherort enthält.

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 Zeichenfolge, die den Pfad zum Paket enthält.

Implementiert

GetPackagePath()

Beispiele

Im folgenden Codebeispiel wird der Paketpfad vom Protokollanbieter zurückgegeben.

using System;  
using System.Collections.Generic;  
using System.Text;  
using Microsoft.SqlServer.Dts.Runtime;  

namespace LogProvider_Expression_Tests  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            // The package is one of the SSIS Samples. The package was  
            // modified to log to the SSIS log provider for Text files  
            // and saved before loading into this code.  

            string mySample = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

            // Create the Application, and load the sample.  
            Application app = new Application();  
            Package pkg = app.LoadPackage(mySample, null);  

            // Get the LogProviders collection.  
            LogProviders logProvs = pkg.LogProviders;  

            // Get the "SSIS log provider for Text files"  
            // provider from the collection.  
            LogProvider textLogProv = logProvs["SSIS log provider for Text files"];  

            // Get the package path from the log provider.  
            String pkgPath = textLogProv.GetPackagePath();  
            Console.WriteLine("Package path: {0}", pkgPath);  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  

Namespace LogProvider_Expression_Tests  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            ' The package is one of the SSIS Samples. The package was  
            ' modified to log to the SSIS log provider for Text files  
            ' and saved before loading into this code.  

            Dim mySample As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"   

            ' Create the Application, and load the sample.  
            Dim app As Application =  New Application()   
            Dim pkg As Package =  app.LoadPackage(mySample,Nothing)   

            ' Get the LogProviders collection.  
            Dim logProvs As LogProviders =  pkg.LogProviders   

            ' Get the "SSIS log provider for Text files"  
            ' provider from the collection.  
            Dim textLogProv As LogProvider =  logProvs("SSIS log provider for Text files")   

            ' Get the package path from the log provider.  
            Dim pkgPath As String =  textLogProv.GetPackagePath()   
            Console.WriteLine("Package path: {0}", pkgPath)  
        End Sub  
    End Class  
End Namespace  

Beispielausgabe:

Paketpfad: \Package.LogProviders[{2A89B1C0-E01E-4E1B-89E3-02DFF291D70}]