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)
Syntax
'Declaration
Public ReadOnly Property FileName As String
Get
'Usage
Dim instance As ForEachEnumeratorInfo
Dim value As String
value = instance.FileName
public string FileName { get; }
public:
property String^ FileName {
String^ get ();
}
member FileName : string
function get FileName () : String
Property Value
Type: System.String
A String that contains the file name of the source data.
Examples
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.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
----------------------------