LogProviderInfo.Name プロパティ
ログ プロバイダーの名前を取得します。値の設定も可能です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public Property Name As String
Get
Set
'使用
Dim instance As LogProviderInfo
Dim value As String
value = instance.Name
instance.Name = value
public string Name { get; set; }
public:
virtual property String^ Name {
String^ get () sealed;
void set (String^ value) sealed;
}
abstract Name : string with get, set
override Name : string with get, set
final function get Name () : String
final function set Name (value : String)
プロパティ値
型: System.String
ログ プロバイダーの名前を表す String です。
実装
使用例
次のコード例では、ログ プロバイダー コレクションに含まれる各ログ プロバイダーのプロパティをすべて取得して繰り返し処理し、FileNameVersionString などの値を出力します。
using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
namespace LogProvInfoProperties
{
class Program
{
static void Main(string[] args)
{
Application app = new Application();
LogProviderInfos infos = app.LogProviderInfos;
foreach(LogProviderInfo info in infos)
{
Console.WriteLine("CreationName {0}", info.CreationName);
Console.WriteLine("Description {0}", info.Description);
Console.WriteLine("FileName: {0}", info.FileName);
//Console.WriteLine("FileNameVersionString: {0}", info.FileNameVersionString);
Console.WriteLine("IconFile: {0}", info.IconFile);
Console.WriteLine("IconResource: {0}", info.IconResource);
Console.WriteLine("ID: {0}", info.ID);
Console.WriteLine("LogProviderContact {0}", info.LogProviderContact);
Console.WriteLine("LogProviderType {0}", info.LogProviderType);
Console.WriteLine("Name: {0}", info.Name);
Console.WriteLine("UITypeName {0}", info.UITypeName);
Console.WriteLine("__________________________");
}
}
}
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Namespace LogProvInfoProperties
Class Program
Shared Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim infos As LogProviderInfos = app.LogProviderInfos
Dim info As LogProviderInfo
For Each info In infos
Console.WriteLine("CreationName {0}", info.CreationName)
Console.WriteLine("Description {0}", info.Description)
Console.WriteLine("FileName: {0}", info.FileName)
'Console.WriteLine("FileNameVersionString: {0}", info.FileNameVersionString)
Console.WriteLine("IconFile: {0}", info.IconFile)
Console.WriteLine("IconResource: {0}", info.IconResource)
Console.WriteLine("ID: {0}", info.ID)
Console.WriteLine("LogProviderContact {0}", info.LogProviderContact)
Console.WriteLine("LogProviderType {0}", info.LogProviderType)
Console.WriteLine("Name: {0}", info.Name)
Console.WriteLine("UITypeName {0}", info.UITypeName)
Console.WriteLine("__________________________")
Next
End Sub
End Class
End Namespace
サンプルの出力 :
CreationName DTS.LogProviderTextFile.1
Description Writes log entries for events to a CSV file
FileName: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconResource: 0
ID: {59B2C6A5-663F-4C20-8863-C83F9B72E2EB}
LogProviderContact
LogProviderType DTS10
Name: SSIS log provider for Text files
UITypeName Microsoft.DataTransformationServices.Design.FileConnectionsLogProviderUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
__________________________
CreationName DTS.LogProviderSQLProfiler.1
Description Generates SQL traces that may be captured in SQL Server Profiler
FileName: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconResource: 0
ID: {5C0B8D21-E9AA-462E-BA34-30FF5F7A42A1}
LogProviderContact
LogProviderType DTS10
Name: SSIS log provider for SQL Server Profiler
UITypeName Microsoft.DataTransformationServices.Design.FileConnectionsLogProviderUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
__________________________
CreationName DTS.LogProviderSQLServer.1
Description Writes log entries for events to a SQL Server database
FileName: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconFile: C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSLog.dll
IconResource: 0
ID: {6AA833A1-E4B2-4431-831B-DE695049DC61}
LogProviderContact
LogProviderType DTS10
Name: SSIS log provider for SQL Server
UITypeName Microsoft.DataTransformationServices.Design.OleDbConnectionsLogProviderUI, Microsoft.DataTransformationServices.Design, Version=10.0.000.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
__________________________