using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace Connections_Item
{
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\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
// Create an application and load the sample.
Application app = new Application();
Package pkg = app.LoadPackage(mySample, null);
Connections conns = pkg.Connections;
//Using the Item method syntax of [x], obtain the
// entire first entry, and then just the name.
ConnectionManager myConnMgr = conns[0];
String nameOfFirstItem = conns[0].Name;
//Print the name of the connection manager located at position [0].
Console.WriteLine("The ID of the first connection info is: {0}", myConnMgr.ID);
Console.WriteLine("The Name of the first connection info is: {0}", nameOfFirstItem);
}
}
}