Share via

IDTSOutput100 Interface

  • Article

Contains the collection of IDTSOutputColumn100 columns available to downstream components in a graph.

Namespace:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Assembly:  Microsoft.SqlServer.DTSPipelineWrap (in Microsoft.SqlServer.DTSPipelineWrap.dll)

Syntax

'Declaration
<GuidAttribute("89B8E306-7C2A-472F-8850-7202B4DAF17B")> _
Public Interface IDTSOutput100 _
    Inherits IDTSObject100
'Usage
Dim instance As IDTSOutput100

[GuidAttribute("89B8E306-7C2A-472F-8850-7202B4DAF17B")]
public interface IDTSOutput100 : IDTSObject100

[GuidAttribute(L"89B8E306-7C2A-472F-8850-7202B4DAF17B")]
public interface class IDTSOutput100 : IDTSObject100

[<GuidAttribute("89B8E306-7C2A-472F-8850-7202B4DAF17B")>]
type IDTSOutput100 =  
    interface 
        interface IDTSObject100 
    end

public interface IDTSOutput100 extends IDTSObject100

The IDTSOutput100 type exposes the following members.

Properties

  Name Description
Public property Buffer Gets the ID of the PipelineBuffer allocated for an IDTSOutput100 object.
Public property Component Gets the IDTSComponentMetaData100 of an IDTSOutput100 object.
Public property CustomPropertyCollection Gets the collection of IDTSCustomProperty100 objects defined for an IDTSOutput100 object.
Public property Dangling Gets or sets a value that notifies the data flow engine that the IDTSOutput100 can be unattached.
Public property DeleteOutputOnPathDetached Gets or sets a value that determines whether the data flow engine deletes an IDTSOutput100 object when it is detached from an IDTSPath100 object.
Public property Description Gets or sets the description of an IDTSOutput100 object.
Public property ErrorOrTruncationOperation Gets or sets text that describes the error or truncation operation of an IDTSOutput100 object.
Public property ErrorRowDisposition Gets or sets a value that specifies how a component proceeds when an error occurs while processing the columns in the output at run time.
Public property ExclusionGroup Gets or sets the ExclusionGroup property of an IDTSOutput100 object.
Public property ExternalMetadataColumnCollection Gets the IDTSExternalMetadataColumnCollection100 of an IDTSOutput100 object.
Public property HasSideEffects Gets or sets a value that indicates whether a data flow component should be removed or remain in the execution plan of a data flow task when its input is not attached to an upstream component and when the RunInOptimizedMode property of the Data Flow task is true.
Public property ID Gets or sets the ID property of an IDTSOutput100 object.
Public property IdentificationString Gets a string that uniquely identifies an IDTSOutput100 object.
Public property IsAttached Gets a value that indicates if the IDTSOutput100 object is attached to another component via an IDTSPath100object.
Public property IsErrorOut Gets or sets a value that indicates whether an IDTSOutput100 object is an error output.
Public property IsSorted Gets a value that indicates whether the columns in an output object are sorted.
Public property Name Gets or sets the name of an IDTSOutput100.
Public property ObjectType Gets the DTSObjectType of an IDTSOutput100 object.
Public property OutputColumnCollection Gets the collection of IDTSOutputColumn100 objects defined for an IDTSOutput100 object.
Public property SynchronousInputID Gets or sets the ID of an IDTSInput100 that is synchronous to an IDTSOutput100.
Public property TruncationRowDisposition Gets or sets a value that determines how a component processes a row where a column has been truncated as a result of its operation on a column in the row.

Top

Remarks

The IDTSOutput100 object contains the collection of IDTSOutputColumn100 columns exposed by a data flow component. The output is connected to the IDTSInput100 of a downstream component to establish the flow of data between two components.

An output can be either synchronous to an IDTSInput100 object, or asynchronous, and is specified by the SynchronousInputID property.

The columns in the output column collection are available to downstream components. Columns are added and removed from the collection at design time.

Examples

The following code example demonstrates a component that creates an IDTSOutput100 that is synchronous to its input during a call to the ProvideComponentProperties method.

public override void ProvideComponentProperties()
{
    IDTSInput100 input = ComponentMetaData.InputCollection.New();
    input.Name = "Input";

    IDTSOutput100 output = ComponentMetaData.OutputCollection.New();
    output.Name = "Output";
    output.SynchronousInputID = input.ID;
}

Public Overrides Sub ProvideComponentProperties() 
 Dim input As IDTSInput100 = ComponentMetaData.InputCollection.New 
 input.Name = "Input" 
 Dim output As IDTSOutput100 = ComponentMetaData.OutputCollection.New 
 output.Name = "Output" 
 output.SynchronousInputID = input.ID 
End Sub

See Also

Reference

Microsoft.SqlServer.Dts.Pipeline.Wrapper Namespace