IDTSOutput100 IDTSOutput100 IDTSOutput100 IDTSOutput100 Interface


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

public interface class IDTSOutput100 : Microsoft::SqlServer::Dts::Pipeline::Wrapper::IDTSObject100
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDual | System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable)]
public interface IDTSOutput100 : Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100
type IDTSOutput100 = interface
    interface IDTSObject100
Public Interface IDTSOutput100
Implements IDTSObject100


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  


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.


Buffer Buffer Buffer Buffer

Gets the ID of the PipelineBuffer allocated for an IDTSOutput100 object.

Component Component Component Component

Gets the IDTSComponentMetaData100 of an IDTSOutput100 object.

CustomPropertyCollection CustomPropertyCollection CustomPropertyCollection CustomPropertyCollection

Gets the collection of IDTSCustomProperty100 objects defined for an IDTSOutput100 object.

Dangling Dangling Dangling Dangling

Gets or sets a value that notifies the data flow engine that the IDTSOutput100 can be unattached.

DeleteOutputOnPathDetached DeleteOutputOnPathDetached DeleteOutputOnPathDetached 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.

Description Description Description Description

Gets or sets the description of an IDTSOutput100 object.

ErrorOrTruncationOperation ErrorOrTruncationOperation ErrorOrTruncationOperation ErrorOrTruncationOperation

Gets or sets text that describes the error or truncation operation of an IDTSOutput100 object.

ErrorRowDisposition ErrorRowDisposition ErrorRowDisposition 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.

ExclusionGroup ExclusionGroup ExclusionGroup ExclusionGroup

Gets or sets the ExclusionGroup property of an IDTSOutput100 object.

ExternalMetadataColumnCollection ExternalMetadataColumnCollection ExternalMetadataColumnCollection ExternalMetadataColumnCollection

Gets the IDTSExternalMetadataColumnCollection100 of an IDTSOutput100 object.

HasSideEffects HasSideEffects HasSideEffects 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.


Gets or sets the ID property of an IDTSOutput100 object.

IdentificationString IdentificationString IdentificationString IdentificationString

Gets a string that uniquely identifies an IDTSOutput100 object.

IsAttached IsAttached IsAttached IsAttached

Gets a value that indicates if the IDTSOutput100 object is attached to another component via an IDTSPath100object.

IsErrorOut IsErrorOut IsErrorOut IsErrorOut

Gets or sets a value that indicates whether an IDTSOutput100 object is an error output.

IsSorted IsSorted IsSorted IsSorted

Gets a value that indicates whether the columns in an output object are sorted.

Name Name Name Name

Gets or sets the name of an IDTSOutput100.

ObjectType ObjectType ObjectType ObjectType

Gets the DTSObjectType of an IDTSOutput100 object.

OutputColumnCollection OutputColumnCollection OutputColumnCollection OutputColumnCollection

Gets the collection of IDTSOutputColumn100 objects defined for an IDTSOutput100 object.

SynchronousInputID SynchronousInputID SynchronousInputID SynchronousInputID

Gets or sets the ID of an IDTSInput100 that is synchronous to an IDTSOutput100.

TruncationRowDisposition TruncationRowDisposition TruncationRowDisposition 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.

Applies to