Export (0) Print
Expand All

Package.GetPackagePath Method ()

 

Applies To: SQL Server 2016 Preview

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

Namespace:   Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public string GetPackagePath()

Return Value

Type: System.String

A value that contains the relative path to the package location.

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

Legacy Code Example

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

Sample Output:

Package Path: \Package

Return to top
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft