Package.GetPackagePath Metode

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Mengembalikan nilai yang berisi jalur relatif ke lokasi paket.

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

public string GetPackagePath ();

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

Public Function GetPackagePath () As String

Mengembalikan

String

Nilai yang berisi jalur relatif ke lokasi paket.

Penerapan

GetPackagePath()

Contoh

Contoh kode berikut menunjukkan cara mengambil jalur paket.

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

namespace Package_API  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            Package pkg = new Package();  
            pkg = app.LoadPackage(@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", null);  
            // Show the package path.  
            Console.WriteLine("Package Path: {0}", pkg.GetPackagePath());  
        }  
    }  
}  

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

Namespace Package_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim pkg As Package =  New Package()   
            pkg = app.LoadPackage("C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx", Nothing)  
            ' Show the package path.  
            Console.WriteLine("Package Path: {0}", pkg.GetPackagePath())  
        End Sub  
    End Class  
End Namespace  

Contoh Output:

Package Path: \Package

Keterangan

Ada beberapa cara untuk menggunakan metode ini GetPackagePath . Selain metode yang ditunjukkan di bagian Contoh, GetPackagePath dapat dipanggil pada salah satu properti dalam paket dan mengembalikan jalur ke properti apa pun. Contoh kode berikut menunjukkan panggilan ke GetPackagePath untuk properti di posisi Properties pertama, kedua, dan ketiga koleksi.

String prop = p2.Properties[0].GetPackagePath(p2);  
Console.WriteLine("Package properties path = " + prop);  

prop = p2.Properties[1].GetPackagePath(p2);  
Console.WriteLine("Package properties path = " + prop);  

prop = p2.Properties[2].GetPackagePath(p2);  
Console.WriteLine("Package properties path = " + prop);  

Contoh Output:

Package path = \Package

Package properties path = \Package.CertificateContext

Package properties path = \Package.CertificateObject

Package properties path = \Package.CheckpointFileName