TaskInfos.Item Property

Retrieves a TaskInfo from the collection.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

public TaskInfo this[
	Object index
] { get; }


Type: System.Object
The name, ID, or index of the TaskInfo to retrieve from the collection.

Property Value

Type: Microsoft.SqlServer.Dts.Runtime.TaskInfo
The TaskInfo object.

If the call to the Contains method returns true, you can access the specified element in the collection by using the syntax TaskInfos[index]. However, if the call to Contains method returns false, this property throws an exception. In C#, this property is the indexer for the TaskInfos class.

The following code example retrieves an item from the collection using two methods. The first method uses the tInfos[0] syntax to retrieve the entire object located in the first position of the collection and place it in the tInfo object. You can now retrieve all properties from the tInfo object as usual. The second method demonstrates how to retrieve a specific property from the first object in the collection.

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();
            TaskInfos tInfos = app.TaskInfos;

            //Using the Item method syntax of [x], obtain the first 
            TaskInfo tInfo = tInfos[0];
            String nameOfFirstItem = tInfos[0].Name;
           //This could also be done using the Name property, as
           //demonstrated by this next line of commented code.
           //TaskInfo tInfo = tInfos["Execute Package Task"];
           //You can also use the ID property.
           // TaskInfo tInfo = tInfos["{8FE4A9F8-D077-436B-9B00-C1EEAEFAFE55}"];

            //Print the name of the task object located at position [0].
            Console.WriteLine("The task ID of the first provider is: {0}", tInfo.ID);
            Console.WriteLine("The Name of the first task is: {0}", nameOfFirstItem);

Sample Output:

The task ID of the first provider is: {8FE4A9F8-D077-436B-9B00-C1EEAEFAFE55}

The Name of the first task is: Execute Package Task

Community Additions