Connections.GetEnumerator Method
Returns a ConnectionEnumerator for use in iterating over the Connections collection.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)
The following code sample creates a ConnectionEnumerator using the GetEnumerator method, and then iterates over the collection.
using System; using System.Collections.Generic; using System.Text; using Microsoft.SqlServer.Dts.Runtime; namespace ConnMgr_GetEnum_Current { 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); // Get the Connections collection from the package. Connections conns = pkg.Connections; //Create the enumerator. ConnectionEnumerator myEnumerator = conns.GetEnumerator(); Console.WriteLine("The collection contains the following values:"); int i = 0; while ((myEnumerator.MoveNext()) && (myEnumerator.Current != null)) Console.WriteLine("[{0}] {1}", i++, myEnumerator.Current.Name); } } }
Sample Output:
The collection contains the following values:
[0] localhost.AdventureWorks
[1] Transaction Summary by Product1