Export (0) Print
Expand All

PipelineComponentInfos.Item Property

Returns a PipelineComponentInfo object from the collection.

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

public PipelineComponentInfo this[
	Object index
] { get; }

Parameters

index
Type: Object
The name, ID, description, or index of the item to locate in the collection.

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

The following code example retrieves an item from the collection using two methods. The first method uses the pInfos[…] syntax to retrieve the entire object located in the first position of the collection and place it in the pInfo object. You can now retrieve all properties from the pInfo object as usual. The second method demonstrates how to retrieve a specific property, the description, from the "merge" object in the collection using the name as the indexer.

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();
            PipelineComponentInfos pInfos = app.PipelineComponentInfos;

            //Using the Item method syntax of [x], obtain the description
            // of the Merge entry.
            PipelineComponentInfo pInfo = pInfos["Merge"];
            String nameOfFirstItem = pInfos["Merge"].Description;
            Console.WriteLine("Description of Merge entry: {0}", nameOfFirstItem);
        }
    }
}

Sample Output:

Description of Merge entry: Merge Transformation

Community Additions

ADD
Show:
© 2015 Microsoft