ConnectionManager.GetPackagePath Method
Gets or sets the path of the package that the connection applies to.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
The following code example returns the package path for the two connections in the package.
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\100\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()); } } } }
Sample Output:
PackagePath: \Package.Connections[{3427BFE1-F10C-4B7E-8E70-E8D9DC7DDBA3}]
PackagePath: \Package.Connections[{48B66F8D-7DFE-4D85-91C7-0999655484B2}]