Metoda DtsProperty.GetPackagePath
Zwraca ciąg zawiera ścieżka względną do lokalizacji określonej pakiet.
Przestrzeń nazw: Microsoft.SqlServer.Dts.Runtime
Zestaw: Microsoft.SqlServer.ManagedDTS (w Microsoft.SqlServer.ManagedDTS.dll)
Składnia
'Deklaracja
Public Function GetPackagePath ( _
o As Object _
) As String
'Użycie
Dim instance As DtsProperty
Dim o As Object
Dim returnValue As String
returnValue = instance.GetPackagePath(o)
public string GetPackagePath(
Object o
)
public:
String^ GetPackagePath(
Object^ o
)
member GetPackagePath :
o:Object -> string
public function GetPackagePath(
o : Object
) : String
Parametry
- o
Typ: System.Object
Obiekt, który zawiera pakiet.
Wartość zwracana
Typ: System.String
A ciąg zawiera ścieżka względną do lokalizacji określonej pakiet.
Przykłady
Poniższy przykład kodu pokazuje różne sposoby pobierania ścieżka pakiet.Jedna wartość jest zwracana z GetPackagePath metoda, za pomocą GetPackagePath na pierwszej właściwość w DtsProperties kolekcja.Inne ścieżka pakiet zwracane jest z GetPackagePath wykonywane bezpośrednio na Package.Dane wyjściowe zawiera wartości zwracane z metod.
// 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
Przykładowe dane wyjściowe:
Package path = \Package
Package properties path = \Package.CertificateContext
Package properties path = \Package.CertificateObject
Package properties path = \Package.CheckpointFileName