DtsProperty.GetPackagePath(Object) Metode
Definisi
Penting
Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.
Mengembalikan String yang berisi jalur relatif ke lokasi paket yang ditentukan.
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
Parameter
- o
- Object
Objek yang berisi paket.
Mengembalikan
String yang berisi jalur relatif ke lokasi paket yang ditentukan.
Contoh
Contoh kode berikut menunjukkan berbagai cara untuk mengambil jalur paket. Satu nilai dikembalikan dari GetPackagePath metode , menggunakan GetPackagePath
pada properti pertama dalam DtsProperties koleksi. Jalur paket lain yang dikembalikan adalah dari GetPackagePath yang diimplementasikan langsung pada Package. Output menunjukkan nilai yang dikembalikan dari metode .
// 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
Contoh Output:
Package path = \Package
Package properties path = \Package.CertificateContext
Package properties path = \Package.CertificateObject
Package properties path = \Package.CheckpointFileName