DtsProperty.GetPackagePath(Object) Metodo

Definizione

Spazio dei nomi:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Restituisce un valore String che contiene il percorso relativo al percorso del pacchetto specificato.

public:
 System::String ^ GetPackagePath(System::Object ^ o);

public string GetPackagePath (object o);

member this.GetPackagePath : obj -> string

Public Function GetPackagePath (o As Object) As String

Parametri

o

Object

Oggetto contenente il pacchetto.

Restituisce

String

Stringa che contiene il percorso relativo al percorso del pacchetto specificato.

Esempio

Nell'esempio di codice seguente vengono illustrati diversi modi per recuperare il percorso del pacchetto. Un valore viene restituito dal GetPackagePath metodo usando la GetPackagePath prima proprietà nella DtsProperties raccolta. L'altro percorso del pacchetto restituito proviene dall'oggetto GetPackagePath implementato direttamente nell'oggetto Package. L'output mostra i valori restituiti dai metodi.

// other Using statements here...  
using Microsoft.SqlServer.Dts.Runtime;  
namespace DtsPropertiesTesting  
{  
class Program  
    {  

        static void Main(string[] args)  
        {  
            // The variable pkg points to the location  
            // of the ExecuteProcess package sample   
            // that is installed with the samples.  
            string packageFile = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";  

            Application application = new Application();  
            Package package = application.LoadPackage(packageFile, null);  

            // Retrieve the information from the Properties collection.  
            // Each item in the collection represents a property on the  
            // Package object.  

            DtsProperties properties = package.Properties;  

            String propertyName;  
            DTSPropertyKind propertyKind;  
            String packagePath;  
            TypeCode propertyType;  

            foreach (DtsProperty property in properties)  
            {  
                propertyType = property.Type;  
                propertyName = property.Name;  
                propertyKind = property.PropertyKind;  
                packagePath = property.GetPackagePath(package);  
                Console.WriteLine("Property Type: {0}, Property Name: {1}, Property Kind: {2}, Package Path: {3} ", propertyType, propertyName, propertyKind, packagePath);  
            }  
        }  
    }  
}  

' other Using statements here...  
Imports Microsoft.SqlServer.Dts.Runtime  
Namespace DtsPropertiesTesting  
Class Program  

        Shared  Sub Main(ByVal args() As String)  
            ' The variable pkg points to the location  
            ' of the ExecuteProcess package sample   
            ' that is installed with the samples.  
            Dim packageFile As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx"   

            Dim application As Application =  New Application()   
            Dim package As Package =  application.LoadPackage(packageFile,Nothing)   

            ' Retrieve the information from the Properties collection.  
            ' Each item in the collection represents a property on the  
            ' Package object.  

            Dim properties As DtsProperties =  package.Properties   

            Dim propertyName As String  
            Dim propertyKind As DTSPropertyKind  
            Dim packagePath As String  
            Dim propertyType As TypeCode  

            Dim property As DtsProperty  
            For Each property In properties  
                propertyType = property.Type  
                propertyName = property.Name  
                propertyKind = property.PropertyKind  
                packagePath = property.GetPackagePath(package)  
                Console.WriteLine("Property Type: {0}, Property Name: {1}, Property Kind: {2}, Package Path: {3} ", propertyType, propertyName, propertyKind, packagePath)  
            Next  
        End Sub  
End Class  
End Namespace  

Esempio di output

Package path = \Package

Package properties path = \Package.CertificateContext

Package properties path = \Package.CertificateObject

Package properties path = \Package.CheckpointFileName