ForEachEnumeratorInfo.FileName Property

Returns the name of the file that is the data source for the ForEachEnumerator. This value is read-only.

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

public string FileName { get; }

Property Value

Type: System.String
A String that contains the file name of the source data.

The following code example retrieves each ForEachEnumeratorInfo from the ForEachEnumeratorInfos collection, and then prints the values for each property, including the FileName.

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

namespace TaskInfos_Item
{
    class Program
    {
        static void Main(string[] args)
        {
            Application app = new Application();
            ForEachEnumeratorInfos feInfos = app.ForEachEnumeratorInfos;

            // Iterate through the collection, 
            // printing values for the properties.
            foreach (ForEachEnumeratorInfo feInfo in feInfos)
            {
                Console.WriteLine("CreationName:   {0}", feInfo.CreationName);
                Console.WriteLine("Description     {0}", feInfo.Description);
                Console.WriteLine("FileName        {0}", feInfo.FileName);
                //Console.WriteLine("FileNameVersionString   {0}", feInfo.FileNameVersionString);
                Console.WriteLine("ForEachEnumeratorContact {0}", feInfo.ForEachEnumeratorContact);
                Console.WriteLine("ID              {0}", feInfo.ID);
                Console.WriteLine("Name            {0}", feInfo.Name);
                Console.WriteLine("UITypeName      {0}", feInfo.UITypeName);
                Console.WriteLine("----------------------------");
            }
        }
    }
}

Sample Output:

CreationName: DTS.ForEachFileEnumerator.2

Description Provides a file system enumerator

FileName C:\Program Files\Microsoft SQL Server\100\DTS\ForEachEnumerators\ForEachFileEnumerator.dll

ForEachEnumeratorContact

ID {62C3D0D9-C6A3-4A08-84F3-6028B2452F41}

Name For Each File Enumerator

UITypeName Microsoft.SqlServer.Dts.Runtime.Enumerators.File.ForEachFileEnumeratorUI, Microsoft.SqlServer.ForEachFileEnumeratorUI, Version=10.0.000.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91

----------------------------

CreationName: DTS.ForEachItemEnumerator.2

Description Enumerates items in a collection of items

FileName C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTS.dll

ForEachEnumeratorContact

ID {62C3D0DC-C6A3-4A08-84F3-6028B2452F41}

Name For Each Item Enumerator

UITypeName Microsoft.SqlServer.Dts.Runtime.Enumerators.Item.ForEachItemEnumUI, Microsoft.SqlServer.ForEachItemEnumeratorUI, Version=10.0.000.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91

----------------------------

Community Additions

ADD
Show: