Поделиться через


Интерфейс IDTSOutput100

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

Пространство имен:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Сборка:  Microsoft.SqlServer.DTSPipelineWrap (в Microsoft.SqlServer.DTSPipelineWrap.dll)

Синтаксис

'Декларация
<GuidAttribute("2D1508D1-9998-4968-B608-D527CBEA99EE")> _
Public Interface IDTSOutput100 _
    Inherits IDTSObject100
'Применение
Dim instance As IDTSOutput100
[GuidAttribute("2D1508D1-9998-4968-B608-D527CBEA99EE")]
public interface IDTSOutput100 : IDTSObject100
[GuidAttribute(L"2D1508D1-9998-4968-B608-D527CBEA99EE")]
public interface class IDTSOutput100 : IDTSObject100
[<GuidAttribute("2D1508D1-9998-4968-B608-D527CBEA99EE")>]
type IDTSOutput100 =  
    interface
        interface IDTSObject100
    end
public interface IDTSOutput100 extends IDTSObject100

Тип IDTSOutput100 обеспечивает доступ к следующим элементам.

Свойства

  Имя Описание
Открытое свойство 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 IDTSObject100. (Производный от IDTSObject100.)
Открытое свойство 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 of an IDTSObject100object. (Производный от IDTSObject100.)
Открытое свойство ID Gets or sets the ID property of an IDTSOutput100 object.
Открытое свойство IdentificationString Gets a string that uniquely identifies an IDTSObject100. (Производный от IDTSObject100.)
Открытое свойство 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 IDTSObject100 object. (Производный от IDTSObject100.)
Открытое свойство Name Gets or sets the name of an IDTSOutput100.
Открытое свойство ObjectType Gets the ObjectType property of an IDTSObject100. (Производный от IDTSObject100.)
Открытое свойство 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.

В начало

Замечания

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.

Примеры

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