Application.TaskInfos プロパティ
TaskInfo オブジェクトを含む TaskInfos コレクションを返します。 このプロパティは読み取り専用です。
名前空間: Microsoft.SqlServer.Dts.Runtime
アセンブリ: Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS.dll)
構文
'宣言
Public ReadOnly Property TaskInfos As TaskInfos
Get
'使用
Dim instance As Application
Dim value As TaskInfos
value = instance.TaskInfos
public TaskInfos TaskInfos { get; }
public:
property TaskInfos^ TaskInfos {
TaskInfos^ get ();
}
member TaskInfos : TaskInfos
function get TaskInfos () : TaskInfos
プロパティ値
型: Microsoft.SqlServer.Dts.Runtime.TaskInfos
アプリケーション内のすべての TaskInfo オブジェクトを含む TaskInfos コレクションです。
使用例
次のコード例では、TaskInfos コレクションを列挙し、ファイルの名前とそのファイルに関連付けられた説明を出力します。
class ApplicationTests
{
static void Main(string[] args)
{
Application app = new Application();
TaskInfos tis = app.TaskInfos;
foreach (TaskInfo x in tis)
Console.WriteLine(x.FileName + "..." + x.Description);
}
}
class ApplicationTests
Sub Main(ByVal args() As String)
Dim app As Application = New Application()
Dim tis As TaskInfos = app.TaskInfos
For Each x As TaskInfo In tis
Console.WriteLine(x.FileName + "..." + x.Description)
Next
End Sub
End Class
サンプル出力:
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\ExecPackageTask.dll...The Execute Package task enables a DTS package to run other packages as part of a workflow.
C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSPipeline.dll...The Data Flow task encapsulates the data flow engine that moves data between sources and destinations providing the facility to transform, cleanse, and modify data as it is moved.
Microsoft.SqlServer.ActiveXScriptTask...Parses and executes an ActiveX script.
Microsoft.SqlServer.ASTasks...Provides ability to execute DDL query statements against an Analysis Services server.
Microsoft.SqlServer.BulkInsertTask...Copies data from a file into database
Microsoft.SqlServer.DmQueryTask...Execute data mining query
Microsoft.SqlServer.ExecProcTask...Executes Win32 executables
Microsoft.SqlServer.FileSystemTask...Perform file system operations such as copying and deleting files
Microsoft.SqlServer.FtpTask...Perform FTP operations such as sending and receiving files