Application.TaskInfos Property
Returns a TaskInfos collection that contains TaskInfo objects. This property is read-only.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Syntax
'Declaration
Public ReadOnly Property TaskInfos As TaskInfos
public TaskInfos TaskInfos { get; }
public:
property TaskInfos^ TaskInfos {
TaskInfos^ get ();
}
/** @property */
public TaskInfos get_TaskInfos ()
public function get TaskInfos () : TaskInfos
Property Value
A TaskInfos collection that contains all the TaskInfo objects in the application.
Example
The following code example shows how to enumerate over the TaskInfos collection and print the name of the file and its associated description.
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
Sample Output:
C:\Program Files\Microsoft SQL Server\90\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\90\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
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.
See Also
Reference
Application Class
Application Members
Microsoft.SqlServer.Dts.Runtime Namespace