PackageInfos.GetEnumerator Method ()

 

Returns an enumerator for use in iterating over the PackageInfos collection.

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

public PackageInfoEnumerator GetEnumerator()

The following code example loads two packages from the Samples folder and saves them to the Integration Services service. It then creates an enumerator and iterates through the packages and prints their names.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace PackageInfoTest
{
    class Program
    {
        static void Main(string[] args)
        {
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\UsingExecuteProcess.dtsx";
            string pkg2 = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";

            Application app = new Application();
            Package p1 = app.LoadPackage(pkg, null);
            Package p2 = app.LoadPackage(pkg2, null);
            p1.Description = "UsingExecuteProcess package";
            p2.Description = "Calculated Columns package";

            app.SaveToDtsServer(p1, null, @"File System\myp1Package", "YOURSERVER");
            app.SaveToDtsServer(p2, null, @"File System\myp2Package", "YOURSERVER");

            PackageInfos pInfos = app.GetDtsServerPackageInfos(@"File System", "YOURSERVER");
            Console.WriteLine("Number of Packages {0}", pInfos.Count.ToString());

            PackageInfoEnumerator iEnum = pInfos.GetEnumerator();

            while (iEnum.MoveNext())
                {
                    String pkgName = iEnum.Current.Name;
                    Console.WriteLine(pkgName); 
                }
         }
    }
}

Sample Output:

Number of Packages 2

myp1Package

myp2Package

Return to top
Show: