ForEachEnumeratorInfo.FileName Property

Artigo
12/03/2008

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)

Syntax

'Declaration
Public ReadOnly Property FileName As String

public string FileName { get; }

public:
property String^ FileName {
    String^ get ();
}

/** @property */
public String get_FileName ()

public function get FileName () : String

Property Value

A String that contains the file name of the source data.

Example

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("----------------------------");
            }
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace TaskInfos_Item
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim app As Application =  New Application() 
            Dim feInfos As ForEachEnumeratorInfos =  app.ForEachEnumeratorInfos 
 
            ' Iterate through the collection, 
            ' printing values for the properties.
            Dim feInfo As ForEachEnumeratorInfo
            For Each 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("----------------------------")
            Next
        End Sub
    End Class
End Namespace

Sample Output:

CreationName: DTS.ForEachFileEnumerator.1

Description Provides a file system enumerator

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

FileNameVersionString 2000.90.1049.0

ForEachEnumeratorContact

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

Name For Each File Enumerator

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

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

CreationName: DTS.ForEachItemEnumerator.1

Description Enumerates items in a collection of items

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

FileNameVersionString 2000.90.1049.0

ForEachEnumeratorContact

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

Name For Each Item Enumerator

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

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Partilhar via