GetPackagePath 메서드

Returns a String that contains the relative path to the package location.

네임스페이스:  Microsoft.SqlServer.Dts.Runtime
어셈블리:  Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)

구문

‘선언
Public Function GetPackagePath As String
‘사용 방법
Dim instance As Package
Dim returnValue As String

returnValue = instance.GetPackagePath()

public string GetPackagePath()

public:
virtual String^ GetPackagePath() sealed

abstract GetPackagePath : unit -> string 
override GetPackagePath : unit -> string 

public final function GetPackagePath() : String

반환 값

유형: System. . :: . .String
A String that contains the path to the package.

구현

IDTSPackagePath. . :: . .GetPackagePath() () () ()

주의

There are multiple ways to use the GetPackagePath method. In addition to the method shown in the Example section, GetPackagePath can be called on any of the properties in the package and return the path to any property. The following code example shows calls to GetPackagePath for the properties in the first, second, and third positions of the Properties collection.

            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);

Sample Output:

Package path = \Package

Package properties path = \Package.CertificateContext

Package properties path = \Package.CertificateObject

Package properties path = \Package.CheckpointFileName

예

The following code example shows how to retrieve the package path.

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

Sample Output:

Package Path: \Package

참고 항목

참조

Package 클래스

Microsoft.SqlServer.Dts.Runtime 네임스페이스