다음을 통해 공유


PipelineComponent 클래스

Defines the base class that is used when developing managed data flow components.

상속 계층

System.Object
  Microsoft.SqlServer.Dts.Pipeline.PipelineComponent
    Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost

네임스페이스:  Microsoft.SqlServer.Dts.Pipeline
어셈블리:  Microsoft.SqlServer.PipelineHost(Microsoft.SqlServer.PipelineHost.dll)

구문

‘선언
Public Class PipelineComponent
‘사용 방법
Dim instance As PipelineComponent
public class PipelineComponent
public ref class PipelineComponent
type PipelineComponent =  class end
public class PipelineComponent

PipelineComponent 유형에서 다음 멤버를 표시합니다.

생성자

  이름 설명
공용 메서드 PipelineComponent Initializes a new instance of the PipelineComponent class.

맨 위로 이동

속성

  이름 설명
공용 속성 BufferManager Gets the IDTSBufferManager100 of the pipeline component.
공용 속성 ComponentMetaData Gets the IDTSComponentMetaData100 for a component.
공용 속성 ErrorSupport Returns an ErrorSupport object that lets the component raise errors, warnings, or other information events based on HRESULTs returned by Integration Services components written in native code.
공용 속성 EventInfos Gets the IDTSEventInfos100 collection of the PipelineComponent object.
공용 속성 LogEntryInfos Gets an IDTSLogEntryInfos100 collection of logging events that the component has registered.
공용 속성 ReferenceTracker Gets the IDTSObjectReferenceTracker100 associated with the component.
공용 속성 VariableDispenser Gets the IDTSVariableDispenser100 of the data flow component.

맨 위로 이동

메서드

  이름 설명
공용 메서드 AcquireConnections Establishes a connection to a connection manager.
공용 메서드 AddErrorOutput Adds an IDTSOutput100 object and marks it as an error output by setting the IsErrorOut property to true.
보호된 메서드정적 멤버 BufferTypeToDataRecordType Returns a managed data type based on an Integration Services data type.
공용 메서드 Cleanup Frees resources and finishes the execution of the component.
보호된 메서드정적 멤버 ConvertBufferDataTypeToFitManaged Gets the appropriate Integration Services DataType from managed code.
보호된 메서드정적 멤버 DataRecordTypeToBufferType Gets the Integration Services DataType that corresponds to a managed type.
공용 메서드 DeleteExternalMetadataColumn Deletes the external metadata column at the specified index from the collection of external metadata columns.
공용 메서드 DeleteInput Deletes an IDTSInput100 object from the IDTSInputCollection100 collection.
공용 메서드 DeleteOutput Deletes an IDTSOutput100 object from the IDTSOutputCollection100 collection.
공용 메서드 DeleteOutputColumn Deletes an IDTSOutputColumn100 object from the IDTSOutputColumnCollection100 collection.
공용 메서드 DescribeRedirectedErrorCode Provides error code information for a PipelineBuffer row added to an output buffer.
공용 메서드 Equals (Object에서 상속됨)
보호된 메서드 Finalize (Object에서 상속됨)
공용 메서드 GetDependentInputs Returns a collection of the input IDs of inputs that are waiting for more data, and thus are blocking the specified input.
공용 메서드 GetErrorOutputInfo Returns the index and ID of the error output of the component.
공용 메서드 GetHashCode (Object에서 상속됨)
공용 메서드 GetType (Object에서 상속됨)
보호된 메서드정적 멤버 idxOfBufferType 인프라입니다. Specifies the type of the buffer index.
보호된 메서드정적 멤버 idxOfDataRecordType 인프라입니다. Specifies the type of the data record index.
공용 메서드 Initialize When overridden in a derived class, initializes a new instance of a custom data flow component.
공용 메서드 InsertExternalMetadataColumnAt Inserts a new external metadata column into the collection of external metadata columns at the specified index.
공용 메서드 InsertInput Adds an IDTSInput100 object to the IDTSInputCollection100.
공용 메서드 InsertOutput Adds a new IDTSOutput100 object
공용 메서드 InsertOutputColumnAt Creates a new IDTSOutputColumn100 object and inserts it into the IDTSOutputColumnCollection100.
보호된 메서드정적 멤버 IsCompatibleNumericTypes Determines whether two numeric data types are compatible to support a conversion from one type to the other.
공용 메서드 IsInputReady Determines which of the inputs attached to a component are waiting for more data, and which have enough data to process and are blocked.
공용 메서드 MapInputColumn Establishes a relationship between an input column and a corresponding external metadata column.
공용 메서드 MapOutputColumn Establishes a relationship between an output column and a corresponding external metadata column.
보호된 메서드 MemberwiseClone (Object에서 상속됨)
공용 메서드 OnDeletingInputColumn Deletes an IDTSInputColumn100 object from the IDTSInputColumnCollection100.
공용 메서드 OnInputPathAttached Called when an IDTSInput100 object is connected to the component through the IDTSPath100 interface.
공용 메서드 OnInputPathDetached Called when an IDTSInput100 object is disconnected from the component through the IDTSPath100 interface.
공용 메서드 OnOutputPathAttached Called when an IDTSOutput100 object of the component is attached to a downstream component.
공용 메서드 PerformUpgrade Upgrades the component metadata to the version of the component installed on the local computer.
공용 메서드 PostExecute Called at the end of component execution, but before Cleanup.
공용 메서드 PreExecute Called after PrepareForExecute, and before PrimeOutput and ProcessInput.
공용 메서드 PrepareForExecute Called before PreExecute.
공용 메서드 PrimeOutput Called at run time for source components and transformation components with asynchronous outputs to let these components add rows to the output buffers.
공용 메서드 ProcessInput Called at run time when a PipelineBuffer from an upstream component is available to the component to let the component process the incoming rows.
공용 메서드 ProvideComponentProperties Called when a component is first added to the data flow task, to initialize the ComponentMetaData of the component.
공용 메서드 RegisterEvents When you are developing a custom data flow component, you override this method to create custom events.
공용 메서드 RegisterLogEntries Registers the events that the component will log.
공용 메서드 ReinitializeMetaData Repairs any errors identified during validation that cause the component to return VS_NEEDSNEWMETADATA at design time.
공용 메서드 ReleaseConnections Frees the connections established during AcquireConnections. Called at design time and run time.
공용 메서드 RemoveAllInputsOutputsAndCustomProperties Deletes each IDTSInput100 and IDTSOutput100 object from the component.
공용 메서드 SetComponentProperty Assigns a value to a IDTSCustomProperty100 of the component.
공용 메서드 SetExternalMetadataColumnDataTypeProperties Sets the data type properties of the specified external metadata column.
공용 메서드 SetExternalMetadataColumnProperty Sets an individual property of an external metadata column.
공용 메서드 SetInputColumnProperty Assigns a value to the IDTSCustomProperty100 of an IDTSInputColumn100 object.
공용 메서드 SetInputProperty Assigns a value to the IDTSCustomProperty100 of an IDTSInput100 object.
공용 메서드 SetOutputColumnDataTypeProperties Sets the data type properties of an IDTSOutputColumn100 object.
공용 메서드 SetOutputColumnProperty Sets the value of an IDTSCustomProperty100 for an IDTSOutputColumn100 object.
공용 메서드 SetOutputProperty Sets the value of an IDTSCustomProperty100 on an IDTSOutput100 object.
공용 메서드 SetUsageType Creates an IDTSInputColumn100 object in the IDTSInputColumnCollection100 of the component and sets the UsageType property of the column.
공용 메서드 ToString (Object에서 상속됨)
공용 메서드 Validate Verifies that the component is correctly configured.

맨 위로 이동

필드

  이름 설명
공용 필드정적 멤버 s_STOCKPROPNAME_COMPFLAGS Contains the name of the ComparisonFlags property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_DELOUTPUTONPATHDETACHED Contains the name of the DeleteOutputOnPathDetached property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_EXCLGROUP Contains the name of the ExclusionGroup property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_HASSIDEEFFECTS Contains the name of the HasSideEffects property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_ISDISTRIBUTABLE Contains the name of the IsDistributable property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_ISERROROUT Contains the name of the IsErrorOut property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_ISSORTED Contains the name of the IsSorted property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_REFMETADATAID Contains the name of the ReferenceMetaDataID property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_SORTKEYPOS Contains the name of the SortKeyPosition property of data flow components.
공용 필드정적 멤버 s_STOCKPROPNAME_SYNCINPUTID Contains the name of the SynchronousInputID property of data flow components.

맨 위로 이동

주의

Inherit from this class to create your own data flow component. This class implements the required component interfaces, IDTSDesigntimeComponent100 and IDTSRuntimeComponent100. You override the base class implementation of these methods to provide the functionality of your component. PipelineComponent provides helper methods in addition to the methods of the component interfaces to help you in developing your component.

The following code example shows a component that implements the DtsPipelineComponentAttribute and inherits from the PipelineComponent class.

using System;
using Microsoft.SqlServer.Dts.Pipeline.Wrapper;
namespace Microsoft.Samples.SqlServer.Dts
{
    [DtsPipelineComponent(DisplayName="SampleComponent")]
    public class SampleComponent : PipelineComponent
    {
        public override ProvideComponentProperties()
        {
            // TODO: Implement component intialization.
        }
        public override DTSValidationStatus Validate()
        {
            // TODO: Implement component validation.
        }
        public override void ProcessInput( int inputID, PipelineBuffer buffer)
        {
            // TODO: For transformation and destination components,
            //  implement code to process incoming rows.
        }
    }
}
Imports System 
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper 
Namespace Microsoft.Samples.SqlServer.Dts 

 <DtsPipelineComponent(DisplayName="SampleComponent")> _ 
 Public Class SampleComponent 
 Inherits PipelineComponent 

   Public Overrides Sub ProvideComponentProperties() 
    ' TODO: Implement component intialization.
   End Sub 

   Public Overrides Function Validate() As DTSValidationStatus 
    ' TODO: Implement component validation.
   End Function 

   Public Overrides Sub ProcessInput(ByVal inputID As Integer, ByVal buffer As PipelineBuffer) 
    ' TODO: For transformation and destination components,
    '  implement code to process incoming rows.
   End Sub 
 End Class 
End Namespace

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Dts.Pipeline 네임스페이스