Compartir a través de


Interfaz IDTSInput100

Contains the collection of columns that represents the data provided to a component in the form of PipelineBuffer objects at run time.

Espacio de nombres:  Microsoft.SqlServer.Dts.Pipeline.Wrapper
Ensamblado:  Microsoft.SqlServer.DTSPipelineWrap (en Microsoft.SqlServer.DTSPipelineWrap.dll)

Sintaxis

'Declaración
<GuidAttribute("24C64129-7317-4E2F-AAF2-80964796E3AE")> _
Public Interface IDTSInput100 _
    Inherits IDTSObject100
'Uso
Dim instance As IDTSInput100
[GuidAttribute("24C64129-7317-4E2F-AAF2-80964796E3AE")]
public interface IDTSInput100 : IDTSObject100
[GuidAttribute(L"24C64129-7317-4E2F-AAF2-80964796E3AE")]
public interface class IDTSInput100 : IDTSObject100
[<GuidAttribute("24C64129-7317-4E2F-AAF2-80964796E3AE")>]
type IDTSInput100 =  
    interface
        interface IDTSObject100
    end
public interface IDTSInput100 extends IDTSObject100

El tipo IDTSInput100 expone los siguientes miembros.

Propiedades

  Nombre Descripción
Propiedad pública Buffer Gets the ID of a PipelineBuffer that is allocated for an IDTSInput100 object and provided to the component in the ProcessInput method.
Propiedad pública BufferBase Infraestructura.
Propiedad pública Component Gets the IDTSComponentMetaData100 of an IDTSInput100 object.
Propiedad pública CustomPropertyCollection Gets the IDTSCustomPropertyCollection100 object of an IDTSInput100 object.
Propiedad pública Dangling Gets or sets a value that notifies the data flow engine that the input can be unattached.
Propiedad pública Description Gets or sets the description of an IDTSInput100 object.
Propiedad pública Description Gets or sets the description of an IDTSObject100. (Se hereda de IDTSObject100.)
Propiedad pública ErrorOrTruncationOperation Gets or sets a String that specifies the types of errors or truncations that can occur while processing a PipelineBuffer row.
Propiedad pública ErrorRowDisposition Gets or sets a value from a DTSRowDisposition enumeration that specifies how the component will handle error conditions that occur when processing a row from a PipelineBuffer object.
Propiedad pública ExternalMetadataColumnCollection Gets the collection of columns that reflects the columns in an external data source, which are used to validate an IDTSInputColumnCollection100 when the component is not connected to the external data source.
Propiedad pública 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 output is not attached to a downstream component and when the RunInOptimizedMode property of the Data Flow task is true.
Propiedad pública ID Gets or sets the ID of an IDTSInput100 object.
Propiedad pública ID Gets or sets the ID of an IDTSObject100object. (Se hereda de IDTSObject100.)
Propiedad pública IdentificationString Gets a String that uniquely identifies anIDTSInput100 object.
Propiedad pública IdentificationString Gets a string that uniquely identifies an IDTSObject100. (Se hereda de IDTSObject100.)
Propiedad pública InputColumnCollection Gets the IDTSInputColumnCollection100 of an IDTSInput100 object.
Propiedad pública IsAttached Gets a value that indicates if an IDTSInput100 is attached to an upstream component through an IDTSPath100 object.
Propiedad pública IsSorted Gets a value that indicates whether the columns in an IDTSInputColumnCollection100 are sorted.
Propiedad pública Name Gets or sets the name of an IDTSInput100 object.
Propiedad pública Name Gets or sets the name of an IDTSObject100 object. (Se hereda de IDTSObject100.)
Propiedad pública ObjectType Gets the DTSObjectType of an IDTSInput100 object.
Propiedad pública ObjectType Gets the ObjectType property of an IDTSObject100. (Se hereda de IDTSObject100.)
Propiedad pública SourceLocale Gets the locale for an IDTSInput100 object.
Propiedad pública TruncationRowDisposition Gets or sets a value that determines how the component handles truncations that occur while processing rows from a PipelineBuffer.

Arriba

Métodos

  Nombre Descripción
Método público GetVirtualInput Gets the IDTSVirtualInput100 object of an IDTSInput100 object.

Arriba

Comentarios

The IDTSInput100 object represents a connection point between two components, and, when connected to the IDTSOutput100 of an upstream component, establishes the flow of data between components. A connection between an IDTSInput100 and an IDTSOutput100 is established through the IDTSPath100 object. The input represents the EndPoint property of the IDTSPath100 object.

At design time, the columns in the IDTSOutputColumnCollection100 of the output that the input is connected to are selected for use by the component. These columns are then available to the component during component execution.

Ejemplos

The following code example demonstrates a component adding an input to its collection in the ProvideComponentProperties method.

using System;
using Microsoft.SqlServer.Dts.Pipeline;
public class DtsSampleComponent : PipelineComponent
{ 
public override void ProvideComponentProperties()
{
IDTSInput100 input = ComponentMetaData.InputCollection.New();
input.Name = "SampleComponentInput0";
}
}
Imports System 
Imports Microsoft.SqlServer.Dts.Pipeline 

Public Class DtsSampleComponent 
Inherits PipelineComponent 

 Public Overloads Overrides Sub ProvideComponentProperties() 
   Dim input As IDTSInput100 = ComponentMetaData.InputCollection.New 
   input.Name = "SampleComponentInput0" 
 End Sub 
End Class