共用方式為


IDTSOutput100 Interface

Definition

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.Guid("1A1504B9-0B44-41A1-A1AC-6918D7B7F41F")]
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
public interface IDTSOutput100 : Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
[System.Runtime.InteropServices.Guid("CB9D0490-4BF1-47AE-8350-3CA9A3252F93")]
public interface IDTSOutput100 : Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100
[System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)]
[System.Runtime.InteropServices.Guid("CD5CEBE0-5D2E-4170-9326-6C8F3B707147")]
public interface IDTSOutput100 : Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSObject100
[<System.Runtime.InteropServices.Guid("1A1504B9-0B44-41A1-A1AC-6918D7B7F41F")>]
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
type IDTSOutput100 = interface
    interface IDTSObject100
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
[<System.Runtime.InteropServices.Guid("CB9D0490-4BF1-47AE-8350-3CA9A3252F93")>]
type IDTSOutput100 = interface
    interface IDTSObject100
[<System.Runtime.InteropServices.TypeLibType(System.Runtime.InteropServices.TypeLibTypeFlags.FDispatchable | System.Runtime.InteropServices.TypeLibTypeFlags.FDual)>]
[<System.Runtime.InteropServices.Guid("CD5CEBE0-5D2E-4170-9326-6C8F3B707147")>]
type IDTSOutput100 = interface
    interface IDTSObject100
Public Interface IDTSOutput100
Implements IDTSObject100
Attributes
Implements

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  

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.

Properties

Buffer

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

Component

Gets the IDTSComponentMetaData100 of an IDTSOutput100 object.

CustomPropertyCollection

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

Dangling

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

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

Gets or sets the description of an IDTSOutput100 object.

ErrorOrTruncationOperation

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

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

Gets or sets the ExclusionGroup property of an IDTSOutput100 object.

ExternalMetadataColumnCollection

Gets the IDTSExternalMetadataColumnCollection100 of an IDTSOutput100 object.

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.

ID

Gets or sets the ID property of an IDTSOutput100 object.

IdentificationString

Gets a string that uniquely identifies an IDTSOutput100 object.

IsAttached

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

IsErrorOut

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

IsSorted

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

Name

Gets or sets the name of an IDTSOutput100.

ObjectType

Gets the DTSObjectType of an IDTSOutput100 object.

OutputColumnCollection

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

SynchronousInputID

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

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