FileName 속성
Returns the name of the file that is the data source for the ForEachEnumerator. This value is read-only.
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)
구문
‘선언
Public ReadOnly Property FileName As String
Get
‘사용 방법
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
속성 값
유형: 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("----------------------------");
}
}
}
}
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
----------------------------