IDTSPackagePath.GetPackagePath Method
Returns a String that contains the relative path to the package location.
Espacio de nombres: Microsoft.SqlServer.Dts.Runtime
Ensamblado: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Sintaxis
'Declaración
Function GetPackagePath As String
string GetPackagePath ()
String^ GetPackagePath ()
String GetPackagePath ()
function GetPackagePath () : String
Valor devuelto
A String that contains the relative path to the package location.
Notas
This interface is inherited by containers. In the Integration Services architecture, containers provide structure and services to tasks. A package is a type of container. The other container types that SSIS includes are the For Loop, Foreach Loop, Sequence, task host containers and event handlers. For more information, see Paquetes de Integration Services.
Ejemplo
The ConnectionManager class inherits from this interface. The following code example shows the ConnectionManager using the GetPackagePath method.
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Connections_Collection
{
class Program
{
static void Main(string[] args)
{
// The package is one of the SSIS Samples.
string mySample = @"C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
// Create an application and load the sample.
Application app = new Application();
Package pkg = app.LoadPackage(mySample, null);
Connections myConns = pkg.Connections;
// Get the package path.
foreach (ConnectionManager connMgr in myConns)
{
Console.WriteLine("PackagePath: {0}", connMgr.GetPackagePath());
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace Connections_Collection
Class Program
Shared Sub Main(ByVal args() As String)
' The package is one of the SSIS Samples.
Dim mySample As String = "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx"
' Create an application and load the sample.
Dim app As Application = New Application()
Dim pkg As Package = app.LoadPackage(mySample,Nothing)
Dim myConns As Connections = pkg.Connections
' Get the package path.
Dim connMgr As ConnectionManager
For Each connMgr In myConns
Console.WriteLine("PackagePath: {0}", connMgr.GetPackagePath())
Next
End Sub
End Class
End Namespace
Sample Output:
PackagePath: \Package.Connections[{3427BFE1-F10C-4B7E-8E70-E8D9DC7DDBA3}]
PackagePath: \Package.Connections[{48B66F8D-7DFE-4D85-91C7-0999655484B2}]
Seguridad para subprocesos
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Plataformas
Plataformas de desarrollo
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Plataformas de destino
Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.
Vea también
Referencia
IDTSPackagePath Interface
IDTSPackagePath Members
Microsoft.SqlServer.Dts.Runtime Namespace